topic Re: comma to separate values missing in Alteryx Designer Desktop Discussions

comma to separate values missing

Eve_3658 — Mon, 02 May 2022 02:06:14 GMT

When i convert the data input from alteryx to CSV. The " " (highlighted in bold below example) has disappear when i open the csv via notepad. May i know how to put it back in alteryx

ID,NAME,AGE

"23434","Norris, Chuck","24"

"34343","Bond, James ""master""","57"

Re: comma to separate values missing

Qiu — Mon, 02 May 2022 02:17:11 GMT

@Eve_3658
I think it has something to do with the "Quota Output Fields" option in the Output tool.
Can you try with different options?

Re: comma to separate values missing

Eve_3658 — Mon, 02 May 2022 05:06:09 GMT

Hi What about only certain quote output should be in csv file? Is there any way to solve? Cos i try our data to upload vendor website without all the quote output, they can't upload.

Re: comma to separate values missing

Qiu — Mon, 02 May 2022 05:16:49 GMT

@Eve_3658
Can you give us the sample of your input and desired output?
I am sure we can make it work somehow.

Re: comma to separate values missing

Eve_3658 — Tue, 03 May 2022 01:19:26 GMT

Address is input file. 1 address is desired output file when open via notepad as i have indicated manually on the " " in the file when you open via notepad. Thanks

Re: comma to separate values missing

Qiu — Tue, 03 May 2022 02:33:26 GMT

@Eve_3658
I interprete you want the " " for each data?

If yes, then it is the option as I have shown in last reply.

Re: comma to separate values missing

Eve_3658 — Tue, 03 May 2022 09:54:53 GMT

No. Not all data need “ “. Workday Id no need “ “. After SG need “ “, postal code need “ “. If you see my notepad I din add all “” in the data as not all data need “ “ which I mentioned previously. Only certain data need “ “