Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Issue with output to .json (adding backslashes??)

neilo80
5 - Atom

Hi all, 

 

I have an issue when i am outputting a file to json format. 

 

The data is all concatenated in to a single field which i then need to output

 

If you view the data in a browse tool, all looks as it should, however, if you open the output file, before AND after each field name and data element, a "\" has been put by alteryx? It is coded in UTF-8 if that makes a difference.

 

How can i prevent this? The output file is for upload in to another system so this creates an annoying manual step before i can do that.

 

Secondly, is there any way i can output the data without the field name title in the json? 

 

Thankyou in advance experts!!

2 REPLIES 2
jdunkerley79
ACE Emeritus
ACE Emeritus

Hi @neilo80 

 

Yes, you can do this. If you output in CSV format you can switch off headers and stop it quoting thing. A configuration like:

jdunkerley79_0-1631633662335.png

should do what you need.

 

You will need to have built it into a single value so you may need to concatenate first.

 

Hope this helps

 

neilo80
5 - Atom

thankyou, that worked perfectly!!

Labels