JSON Value output = only strings

Hi!

I created my JSON output successfully but now have two final formatting issues. 1. The word JSON is included in the output. Any ideas how to remove this? 2. All values are strings. I would like to specify, based on the key name if it should be read as an int, or date. Screenshot attached.

Thanks for your help!

Cari

Screenshot at Nov 08 12-47-41.png

Output

Accepted answers

jdunkerley79

You have to put the values in different columns: e.g.

You can then specify which columns to use to write to:

Finally write out. As I have already built the JSON I don't want to write as JSON just a flat file (I chose a CSV with no headers) and the output looks like:

{"closed_account":[{"ACY_CURR_BALANCE":0,"Account_No":"300","BRANCH_CODE":"20000","Last_Trn_Date":"2015-04-21","SL":1,"STATUS":"Closed"}]}

Sample attached

JSONOutput.yxmd

All comments

jdunkerley79

You have to put the values in different columns: e.g.

You can then specify which columns to use to write to:

Finally write out. As I have already built the JSON I don't want to write as JSON just a flat file (I chose a CSV with no headers) and the output looks like:

{"closed_account":[{"ACY_CURR_BALANCE":0,"Account_No":"300","BRANCH_CODE":"20000","Last_Trn_Date":"2015-04-21","SL":1,"STATUS":"Closed"}]}

Sample attached

JSONOutput.yxmd

ccaprio

This is great, thank you!

ccaprio

Other than creating a bunch of "if then formula statements", is there an easier way to go from Name + Value keys (created after transpose) to create double and date fields that can then be used in the JSON creation?

Thanks!

Cari

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703