Newbie Questions

Re: Splitting merged data

ErnestoM — Fri, 21 Dec 2012 13:02:35 GMT

I'm a bit confused.

There's a difference between the XML contents and the promoted property.

You can set the promoted property to merge the contents. But that affects only the column (promoted property) and leaves the XML data intact.

I'm guessing that you could merge the data within the form, and use a specific delimiter (which doesn't occurr in the data). So let's say you use a delimiter like *.

Then, when the data is queried, you could (using code, I think) break up that data back into a repeating structure, based on the *.

It's a bit complex; we could try doing this using the DelimitedList command in qRules, but it should be possible using code as well. Good luck!

Re: Splitting merged data

infopathfreak — Fri, 21 Dec 2012 05:23:24 GMT

Thanks for the reply ErnestoM. For some reason I can't attach the XSN.

Yes, I merged the data using eval function in a separate field then submitted to form library as the XML.

First, I tried to use merge function while promoting fields. Even in this method also, I got merged data only as single column in the repeating table.

Re: Splitting merged data

ErnestoM — Thu, 20 Dec 2012 12:28:28 GMT

So the data is merged before submitting the XML?

Could you attach the XSN published to your form library? You can attach via the Options tab. Thanks.

Re: Splitting merged data

infopathfreak — Thu, 20 Dec 2012 05:00:37 GMT

I merged repeating table rows with a delimiter. Through secondary data source I am getting merged data only. If it is possible could you please explain the method.

Re: Splitting merged data

ErnestoM — Tue, 18 Dec 2012 12:25:21 GMT

Splitting the merge data is probably something that you won't be able to accomplish with out of the box InfoPath. Maybe with code.

But why do that? Can't you query to get the entire XML document and that secondary data source will contain the repeating data (unmerged). Won't that work for your scenario? Tell us more...

Splitting merged data

infopathfreak — Wed, 12 Dec 2012 09:05:30 GMT

Hi, I merged all values of repeating table column wise and stored in sharepoint point form library using eval function. Now, I want to display that data as repeating table in another infopath form. I tried to grab the data from form library but only merged data coming as a single column. How can I split that as a repeating table? Please help me.