Converting JSON format to desired CSV format

[amitglko]

Hi I am looking to convert the JSON format file (attached fixings.txt, saved as txt as JSON cannot be uploaded) to the following format of CSV( attached file -AUD...CSV). Have used Python to convert but not getting how to do so using Alteryx. Also want to know how we can convert back from this CSV file to JSON format for upload in other systems. Any help is appreciated. Thanks.

[gabrielvilella]

Hi @amitglko, here is one way of doing this, getting to that table and then changing it back to JSON.

[Qiu · Accepted solution]

@amitglko 
Some thing like this?

[amitglko · Accepted solution]

Thanks @gabrielvilella...the file fixings.txt is actually a JSON file...when I am using your workbook I am getting some errors using the same txt file. Can you take in anyone of the JSON file attached in the zip folder. Thanks a lot.

[Qiu · Accepted solution]

@amitglko 

[atcodedog05 · Accepted solution]

Hi @amitglko 

Here is another way of doing it. 

You can read it all files at once by using wildcard * in the name where it changes

Workflow: you can select and filter the required columns.

Hope this helps : )

[atcodedog05 · Accepted solution]

Happy to help : ) @amitglko 

Cheers and have a nice day!

[amitglko]

Thanks. Two points to note here a) in Input tab you used Unicode UTF-8 for JSON file and b) to recombine the output back to json I can use your earlier workflow. Again thanks a lot.

[Qiu]

@amitglko 
Thank you for accepting my answer.

[amitglko]

Thanks a lot...This solves.