Transform single record to 2 records in CSV

[manohar]

Hi there,

I am trying to split this into 2 records as below and write it to a csv file. Can anyone suggest how I can do this?

NAME	ACTIVE	STL_TEXT	STL_CODE	KRS_CODE	PARENT_KRS_CODE
John Dow Equipment LLC	Yes	Sample Equipment	267817	3486
John Dow Equipment LLC	Yes	NA	NA	NA	3486

Thanks
Manohar

<UCC>
<IDOC BEGIN="1">
<UCC SEGMENT="1">
<ACTIVE>Yes</ACTIVE>
<STL_TEXT>Sample Equipment</STL_TEXT>
<TXT>John Dow Equipment LLC</TXT>
<STL>267817</STL>
<KRS>3486</KRS>
</UCC>
</IDOC>
</UCC>

Also this is what I have so far… am I goin in the right direction?

[dmiller]

Can you clarify what you want in each record?

[manohar]

Hi Diane, updated the original post.

[manohar · Accepted solution]

looks like thats the solution. it worked fine.