Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I'm facing an issue with an incremental load in Qlikview.
The troubles started when I have been changed the source file from .txt to .xlsx therefore I had to slightly modify the script to reload it correctly. The issue is however related to the QVD with the historical data.
Here's what happens:
If I load the QVD with a LOAD * or a LOAD with explicit field names it loads with the correct formats without any problem.
But I need it to be concatenated to the new data I'm pulling off my excel file.
During the script the excel is loaded in memory, I add a comparison field for the NOT EXISTS clause and finally
Concatenate (In memory table)
LOAD * FROM [QVD.QVD] (qvd)
WHERE NOT EXISTS (KEY,COMPARISONFIELD);
The comparison field happens to be a Date in DD/MM/YYYY format.
But whenever I concatenate it turns into a number (and obviously fails the check of the NOT EXISTS).
Any idea on how to solve that?
I even tried loading explicit field names with the date() function with no success.
The issue was that I thought they were dates. They looked like dates but they were numbers. So when the QVD was appended, it kept the original format and turned dates into numbers.