Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Is anyone else experiencing wrong results when using Interval Match in the load script where dates are concerned?
Thank you.
How is your script looks like?
I have a whole list of transactions with vendor information.
Based on the time of the transaction, I want to match information such as their respective categories or their consolidated vendor name.
My script is as such.
AllTransactionDates:
load
Ref.Transaction Date,
Ref.Vendor Number
from xxx.QVD;
[Reference_Table]:
LOAD
Ref.Date,
Ref.Vendor Number,
Ref.Consolidated Vendor Name,
Ref.Supplier Categorization
Resident qReference_Table
Order By Ref.Vendor Number, Ref.Date Desc
;
// Lastly, Interval Match criteria
Inner Join IntervalMatch ("Ref.Transaction Date","Ref.Vendor Number")
Load
"Ref.FromDate",
"Ref.ToDate",
"Ref.Vendor Number"
Resident Reference_Table;
What I find strange is that when I load the exact same script in the Sept release of QlikSense, it gives me the expected results.
However, when I load that same script in the Feb 19 release of QlikSense, it gives me blank values.
Creating dummy data to test the intervalmatch function gives me correct values, so I am baffled as to why this might happen.
Wondering if anyone else encountered such a situation so it can help narrow down my troubleshooting process.