Transform single record to 2 records in CSV

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?

Can you clarify what you want in each record?

Hi Diane, updated the original post.

1 Like

looks like thats the solution. it worked fine.

1 Like