Hello all,
my data is like
info_t | data_t |
["first_name","last_name","age","height"] | ["sam","john","35","6.5ft"] |
and I would like the output as
first_name | last_name | age | height |
sam | john | 35 | 6.5ft |
I have tried several steps such as "fold an array" and transpose the row to a column but I am able to perform this task for one column only (as there is no option to perform this task for multiple columns), and the information in data_t column repeats for every new column that I have created. The results that I am getting is similar to this
first_name | last_name | age | height |
["sam","john","35","6.5ft"] | ["sam","john","35","6.5ft"] | ["sam","john","35","6.5ft"] | ["sam","john","35","6.5ft"] |
Thank you for your assistance.
Robel.
Hi,
Actually a valid JSON object would be more:
{"first_name":"sam","last_name":"john","age":"35","height":"6.5ft"}
If you cells were formatted as a JSON object you would then be able to use in a "Prepare recipe" the "Unnest object" step that would provide the expected output:
So the simplest options I see would be to:
I hope this helps.
Regards,