Number and date concatenation giving issue while saving data in.csv

[pra_kale]

Hi,

I am facing a problem while saving data into .csv format. I am concatenating policy number and date field and want to be get saved same field in a text format. I have converted date into text and concatenated same with policy number and saving out put into .csv.

But when i am opening the file the same field is getting converted into numeric and last digit of date is also wrongly converted into 0 rather then 6.

Please help to resolve the issue.

Thanks in advance.

[sinanozdemir]

Hi,

In the last load script, maybe try to wrap "Policy_Number&''&New-Date1" with Text() function: