I'm new to alteryx and before posting my issue, I looked as much as I could to see if there were any similar ones before and I couldn't find any. I'm trying to move data from Jason file to a tabular format. Lot of examples in this forum helped me in getting to a point where I'm able to parse the Jason file and split the different levels of data into corresponding columns. Here is where I hit the road block. I want to transpose summerized(higher level) rows into columns in the form of repeated values.
Convert this :
| JSON_Name6 | JSON_Name7 | JSON_Name9 | JSON_Name10 | JSON_ValueString |
| 0 | PROD_GRADES | 0 | CODE | Diesel |
| 0 | PROD_GRADES | 0 | PRICE | 1.149 |
| 0 | PROD_GRADES | 0 | CHANGEFLAG | SAME |
| 0 | PROD_GRADES | 1 | CODE | Super E5 |
| 0 | PROD_GRADES | 1 | PRICE | 1.329 |
| 0 | PROD_GRADES | 1 | CHANGEFLAG | SAME |
| 0 | PROD_GRADES | 2 | CODE | Super E10 |
| 0 | PROD_GRADES | 2 | PRICE | 1.309 |
| 0 | PROD_GRADES | 2 | CHANGEFLAG | SAME |
| 0 | UNIQUEID | | | 60d394d5-7514-46b4-8d6f-b3539a982fc0 |
| 0 | CODE | | | |
| 0 | CURRENCY | | | EUR |
| 0 | VOLUMEUNIT | | | LITER |
| 0 | QUERYSURVEYDATE | | | 2018-02-16 01:44:54 |
| 1 | PROD_GRADES | 0 | CODE | Diesel |
| 1 | PROD_GRADES | 0 | PRICE | 1.119 |
| 1 | PROD_GRADES | 0 | CHANGEFLAG | SAME |
| 1 | PROD_GRADES | 1 | CODE | Super E10 |
| 1 | PROD_GRADES | 1 | PRICE | 1.279 |
| 1 | PROD_GRADES | 1 | CHANGEFLAG | SAME |
| 1 | PROD_GRADES | 2 | CODE | Super E5 |
| 1 | PROD_GRADES | 2 | PRICE | 1.319 |
| 1 | PROD_GRADES | 2 | CHANGEFLAG | SAME |
| 1 | UNIQUEID | | | 2ab8e58f-64bf-4f4b-a9d4-ad1519ffe2ad |
| 1 | CODE | | | |
| 1 | CURRENCY | | | EUR |
| 1 | VOLUMEUNIT | | | LITER |
| 1 | QUERYSURVEYDATE | | | 2018-02-16 01:44:54 |
To:
| UNIQUEID | CODE | CURRENCY | VOLUMEUNIT | QUERYSURVEYDATE | CODE | PRICE | CHANGEFLAG |
| 60d394d5-7514-46b4-8d6f-b3539a982fc0 | | EUR | LITER | 2018-02-16 01:44:54 | Diesel | 1.149 | SAME |
| 60d394d5-7514-46b4-8d6f-b3539a982fc0 | | EUR | LITER | 2018-02-16 01:44:54 | Super E5 | 1.329 | SAME |
| 60d394d5-7514-46b4-8d6f-b3539a982fc0 | | EUR | LITER | 2018-02-16 01:44:54 | Super E10 | 1.309 | SAME |
| 2ab8e58f-64bf-4f4b-a9d4-ad1519ffe2ad | | EUR | LITER | 2018-02-16 01:44:54 | Diesel | 1.119 | SAME |
| 2ab8e58f-64bf-4f4b-a9d4-ad1519ffe2ad | | EUR | LITER | 2018-02-16 01:44:54 | Super E5 | 1.279 | SAME |
| 2ab8e58f-64bf-4f4b-a9d4-ad1519ffe2ad | | EUR | LITER | 2018-02-16 01:44:54 | Super E10 | 1.319 | SAME |
Thanks in advance!!
