parse and combine column

[jillv]

Hi

I am having a hard time to parse and combine the columns of a nested json after cross tab. I am stuck on the below:

RecordID	cusip2Set_cusip2Record_0_code	cusip2Set_cusip2Record_0_identifier	cusip2Set_cusip2Record_1_code	cusip2Set_cusip2Record_1_identifier
1	A	123456789	I	US1234567892
2	I	US23456677775

the result i am expecting would be something like the below

RecordID	A	I
1	123456789	US1234567892
2		US23456677775

thank you in advance!

[ShankerV]

Hi @jillv 

Please find the expected output.

One way of doing this.

[binuacs]

@jillv Another approach

[Raj]

In this case bot of the following workflows work properly but i suggest you to go with 1st one from image to perform automation in workflow

[jillv]

@binuacs  thanks, however, the value for the highlighted below is not correct, it should be US1234567892. :(

[BS_THE_ANALYST · Accepted solution]

@jillv one way:

[binuacs · Accepted solution]

@jillv updated workflow attached