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

pra_kale — Mon, 21 Nov 2016 16:32:04 GMT

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.

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

sinanozdemir — Mon, 21 Nov 2016 17:44:09 GMT

Hi,

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

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

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

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