"0" is missing in the output csv file

[Nina00000]

Dear comunity,

i have issue of "0" is missing in output csv file - even in the designer display shows "0".

for example,

I need "Time" column with "YYYY.MM" format. e.g. (2020.10)

Formura i currently use is following:

Replace(Substring(DateTimeAdd(DateTimeToday(),-1,"month"),0,7), "-", ".")

In the alteryx design tool, result is displayed as "2020.10".

However, when i open output csv file, the cell is wrriten as "2020.1" - missing "0")

also, i have same issue of leading 0 is missing in the out put file in other kind of ID column.

could you please kindly share the solution..?

[grazitti_sapna]

Hi @Nina00000 , I understood your problem what is happening in your csv is the datatype is being read as general

when you change its data type to number you will get the correct output.

Well that is one step that you can perform in order to achieve the desired output.

Thanks.

[Nina00000]

Thank you, I tried to change "Number", and it worked!!

just one issue is ,

are there anyway i can automate this process by Alteryx? (csv output format from "General" to " Number")

Since i have so many csv output files in the end, so i'd like to avide change data format mannually ( very hard work)...

I appriciate your advice!  😀　

[atcodedog05]

Hi @Nina00000 

Just a thought is there a mandate that date format should be in 2020.10 format if its changed to 2020-10 you will not face this issue.

[Nina00000]

Hi, thanks for your advice.

Yes, i need this 2020.10 format due to system uploading afterward..

Thank you!

[grazitti_sapna]

Hi @Nina00000 , what I think is 2020.10 is being read as decimal number as per csv and in general the csv removes the trailing zeroes that is why you are facing this issue.

I faced similar issue couldn't find anything except the solution I provided earlier.

Thanks.