Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All -
I'm trying to convert the date of a field via the Data Manager from "general" to date. When I do this, it turns all the fields to null. I went back tot he source file and converted the field to "date" and that didn't work either ... qlik sense still pulls it in as general. Conversion still turns everything to null.
Any help?
Could you please provide some screenshots?
Hi
may have to use conversion function if applicable
Date (dayname (field_date), 'YYYY-MM-DD'))
Regards
Thanks for the response! Where would I put that? I'm hesitant to mess with the load script (i'm a newbie and completely ruined my app last time I did that!)
Put it as an additional field in the middle of the table.
if it goes wrong just delete the additional line
Load
...,
...,
field _name_date,
Date (dayname (field _name_date), 'YYYY-MM-DD')) as field _name_date_2,
...,
...,
...,
From .....
in place of the field _name_date put the correct field name
Pretty sure I did that wrong:
wen't here:
And crated a new section ... put your script in below and it didn't work. Where should I have put it?
apparently the script is short
Paste the original script here, so it is easier to say the line