JSON Value output = only strings

[ccaprio]

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

[jdunkerley79 · Accepted solution]

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

[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