comma to separate values missing

Question

Hi

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"

Eve_3658 · Answer

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 “ “

Qiu · Answer

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

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

0503-Eve_3658.yxzp

Eve_3658 · Answer

Hi

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

Address.xlsx

1  Address.csv