In the below question first three elements of xml should is common for all xml profiles from first line of text and rest from third ,fourth,fifth....upto 8 records please help
I'm trying to understand what you ask.
Hi Rakesh.. did you mean that the values from the first line of your text file is common for all records in the XML profile?
If that is so then you can try doing the following:
(1) Before you do a map function put a Branch Shape.
(2) Inside the first branch add a Data Process Shape to split your text file on each line. Add a Decision Shape to check if the Dynamic Process Properties is blank. If it is blank, then set the values of these Dynamic Process Properties using Set Properties Shape. If it is not blank, then just End and Continue. So this will make sure that only the first line of your text-file is used for filling the DPPs which stores the common values.
(3) Now in your second branch use the normal Map Shape to map your Text to XML. For the first three mappings of the XML element use the Dynamic Process Properties using Map Function. For rest of the elements you can directly map from the text field to the XML elements.
This is how your process will look:
This is how your csv to xml mapping will look like:
Hope this solves your problem.
Retrieving data ...