I have a table that has a key field and one field with a line of | pipe delimited data like this:
I have a script component that breaks this down as follows:
What I want is a horizontal row, not a vertical one.
ID FIELD1 FIELD2 FIELD3 FIELD4 FIELD5 FIELD6 FIELD7
1 20120828 20 20.500 CLO ISYS LFCT LPMCO-LP2
Is there something that I can use in Script Component? Right now it does an .AddRow.