Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor III

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

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.

1 Reply
Highlighted
Valued Contributor III

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

Hi,

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

Capture.PNG