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: RecordIDcusip2Set_cusip2Record_0_codecusip2Set_cusip2Record_0_identifiercusip2Set_cusip2Record_1_codecusip2Set_cusip2Record_1_identifier1A123456789IUS12345678922IUS23456677775 the result i am expecting would be something like the below RecordIDAI1123456789US12345678922 US23456677775 thank you in advance!

parse and combine column

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

thank you in advance!

Regex

@jillv one way:

@jillv updated workflow attached

Please find the expected output.

One way of doing this.

@jillv Another approach

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

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

@jillv one way:

@jillv updated workflow attached