Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

DateTime issue. My results give Text and Numeric in same field? Can't convert to date, only int/num

Hi Everyone

When I import my date into qlik from a CSV, the field has the tag numeric only. It contains date time data.

I have tried converting in a few ways but I can see that qlik is seeing two different types of data. When I try convert to text, remove spaces and then split into the date format it shows two alignments on the field. So text and numeric?

Has this ever happened to anyone? The CSV is large and am struggling to open it anywhere outside of QlikSense at the moment.

I just want the date, 'DD/MM/YYYY'...

 

Issue.PNG

James

Labels (3)
3 Replies
Contributor

Re: DateTime issue. Text and Numeric in same field. Can't convert to date.

Hi,

Try using this in load script to convert to date..

Date(Date#(field name,'DD/MM/YYYY'))
Highlighted
Partner
Partner

Re: DateTime issue. Text and Numeric in same field. Can't convert to date.

Thank you for responding.

I have tried that as well as even loading left(Date,4) as year, doing the same for month and year. For each part. Then loading in another table as makedate() using year, month and day. 

Still, I only get numeric fields which is why I am so stuck in this case. The origin of this data before it was a CSV extract was MySQL where it reflects as datetime.

 

 

Highlighted
Partner
Partner

Re: DateTime issue. Text and Numeric in same field. Can't convert to date.

This is a zippedQVD Extract of the Date column that I am struggling to convert