Format and output a json file

Question

Hi Alteryx community,

I'm trying to turn two columns of numbers into one string of text and output as .json file. For example:

Input excel file:

Output .json file:

{"Data":[{"Key":"127623.283718"},{"Key":"126799.283935"}.........{"Key":"129454.296223"}]}

I literally don't even know where to start...Please send help.

Thank you.

Felipe_Ribeir0 · Answer

Hi @Meiye, here is a way to achieve this :)

Format_and_output_json_file.yxmd

DanielMS · Answer

Hi @Meiye

The JSON Build tool will allow you to do this. Note: Prior to the data going into the JSON build tool, it should already be in Name:Value pairs which you can achieve using the Transpose tool.

To output this JSON, you will add an Output data tool after the JSON Build tool. Because it is already in the JSON format, it would be best to output to a txt format.

Hope this helps!

Dan