cancel
Showing results for 
Search instead for 
Did you mean: 

Transform single record to 2 records in CSV

manohar
Contributor

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?

image

1 ACCEPTED SOLUTION

manohar
Contributor

looks like thats the solution. it worked fine.

View solution in original post

3 REPLIES 3

dmiller
Former Employee

Can you clarify what you want in each record?


Diane Miller

Hi Diane, updated the original post.

manohar
Contributor

looks like thats the solution. it worked fine.