Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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,