Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon,
i would like to identify a field as a data field in the import script area. (I need this for a qlik extension.) What should i write?
Like:
LOAD
ABC AS $data
FROM [.......]
? It doesn't work.
Thanks.
It seems you are trying to extract a DATE from a timestamp field. The community may be able to help with this.
Looking at your example, it looks like the final step would be to convert the number back into a date, as the Floor function will output an integer.
Just wrap what you have in the Date() function to accomplish this.
Date(Floor(Date#(ds, 'YYYY-MM-DD hh:mm:ss TT'))) as Period
The best way to enable the community to help is provide a small sample of the data you are trying to convert.
If the issue is not with Qlik Sense, but the extension, generally speaking the best place to find extension specific support is from the extension author.
Technically speaking, all fields are data fields. Without specifics, it may be the extension is asking you to TAG a field a certain way. If this is the case, check out the help article on using field tags.
https://help.qlik.com/en-US/sense/latest/Subsystems/Hub/Content/Sense_Hub/Scripting/field-tags.htm
Hope this helps.
Thanks Tom.
i tried something like this ..... Floor(Date#(ds, 'YYYY-MM-DD hh:mm:ss TT')) as Period....
but it doesn't work....
It seems you are trying to extract a DATE from a timestamp field. The community may be able to help with this.
Looking at your example, it looks like the final step would be to convert the number back into a date, as the Floor function will output an integer.
Just wrap what you have in the Date() function to accomplish this.
Date(Floor(Date#(ds, 'YYYY-MM-DD hh:mm:ss TT'))) as Period
The best way to enable the community to help is provide a small sample of the data you are trying to convert.
If the issue is not with Qlik Sense, but the extension, generally speaking the best place to find extension specific support is from the extension author.