"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..?

Emil_Kos

Hi @Nina00000,

Change the data type to string and it should work.

If it is already strung please let me know.

If this was something helpful please mark as a solution!

Thanks!