I'm working on a workflow that reads JSON data and processes the relevant datapoints into tabular data. I got to the following format after a series of Select, Filter, and Formulas once reading from the Json Parser:
JSON_Name | JSON_ValueString |
id | 123 |
firstName | John |
Office | New York |
Revenue | 150,000 |
id | 135 |
firstName | Mary |
Office | Chicago |
Revenue | 230000 |
id | 179 |
firstName | Joe |
Office | Miami |
Revenue | 175000 |
You can see it's 4 rows repeating with different values. How can I transform into the following structure?
id | firstName | Office | Revenue |
123 | John | New York | 150000 |
135 | Mary | Chicago | 230000 |
179 | Joe | Miami | 175000 |
Thanks for any suggestions in advance.
Solved! Go to Solution.
Hi @1737280 ,
Attached is an example showing how to do it.
Let me know if this works for you.
Best,
Fernando Vizcaino
Thank you @fmvizcaino. Adding the dummy field as the key wasn't what I thought of. ; ) 🙂 It works perfectly!