Converting JSON format to desired CSV format

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.

fixings.txt

AUD-BBSW-BBSW-3M.csv

Parse

Accepted answers

Qiu

@amitglko
Some thing like this?

0301-amitglko.yxzp

amitglko

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.

ezyzip.zip

Qiu

@amitglko

0301-amitglko-r1.yxzp

atcodedog05

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 : )

json to csv.yxmd

atcodedog05

Happy to help : ) @amitglko

Cheers and have a nice day!

All comments

gabrielvilella

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

JSON Parse.yxmd

Qiu

@amitglko
Some thing like this?

0301-amitglko-r1.yxzp

atcodedog05

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 : )

json to csv.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703