Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am loading data from an xlsx file. There is a column present in the file which has values in datetime format such as 1/3/2015 17:45.
While loading it in qlikview, I am getting it in number format.
How do I get the timestamp format in which the data is present in the excel into the specific column in the script?
Thanks,
Asma
Use the Timestamp() function to format the number into a timestamp. By the below principle.
LOAD
Timestamp(MyTimestampField) AS MyTimestamp
FROM myfile.xlsx
If you need more detailed help a sample XLSX file and QVW file would make it a lot easier to understand what happens in your scenario.
Hi,
Try any of the below two
Timestamp(fieldName,'DD/MM/YYYY hh:mm')
or
Date(fieldName,'DD/MM/YYYY hh:mm')
Regards
It is worth mentioning that all datetimes in qlikview is represented by floating point number. the whole number is the days passed since 31 December 1899 and the fractional value is the time.
using the previously mentioned function will put them in the format we know.