I have source Data from 3 fields from a file and these has to be loaded into one Target Column.
ID Error1 Error2 Error3
100 AB CD
101 AC EF GH
102 AD EF
Please help on this..
Happy to help.
Please mark as "correct anwer".
I created below test process which maybe can be used as a template.
After mapping to Flat File Profile "Destination", I split the document in a Data Process Shape to a new Flat File Profile "Destination2", Link Element TGTCOL
Decision shape cleans out the empty TGTCOL's
Documents combined in a Data Process Shape
Line Item Increment sets the PRIMARY_KEY
Finally this document ends up in the message shape at the end:
Best regards, Leif Jacobsen
Thank you This helps!!
Retrieving data ...