I have a dataset that contains a series of columns that are numbered, where four columns that are related will have the same number and then the next four will be numbered with the subsequent integer. Example:
Identifier_1.id
Identifier_1.Type Code
Identifier_1.State
Identifier_1.Issuer
Identifier_2.id
…
123456
1
GA
AETNA
7891011
?
These go up to integer 50, so in total there are 200 columns. I want to try to combine these into a list of JSON objects in a single column. The output would look something like this:
So this worked, and I was able to adapt it using a Column List Loop to get it to work for multiple rows so that each list of JSON objects for each row would be stored in separate rows.
However, it breaks when there are rows that have empty cells or mismatched dimensions. Example: