This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
I am using the following code to generate a mapping table:
BGRAD:LOAD Distinct PERNR, BSGRD, Num#(BEGDA) AS BStart, Num#(ENDDA) AS BEndFROM [..\DATA\00-08000000-90-100-PA0008.qvd](qvd);Inner Join IntervalMatch (DATUM_SAP, PERNR)LOAD Distinct BStart, BEnd, PERNRResident BGRAD;mBGRAD:MappingLOAD Distinct PERNR & '-' & DATUM_SAP AS %key, BSGRDResident BGRAD;
for DATUM_SAP I use this code:
For y=Year(Today()) to (Year(Today())+5)For m=1 to 12CAL:LOADMakeDate($(y),$(m),1) AS DATUM_REAL,Num(MakeDate($(y),$(m),1)) AS DATUM_SAPAutoGenerate(1);
And yet, as I execute the script, it fetch 0 lines, as the log file displays:
BGRAD << 00-08000000-90-100-PA0008 25.063 Lines fetchedBGRAD 0 Lines fetchedmBGRAD << BGRAD 0 Lines fetched
Any idea what could be the cause of this behavior/result?
Can you share how your data looks within 00-08000000-90-100-PA0008.qvd? I think it might have to do with BStart and BEnd not getting read as dual fields with an underlying numeric value.
Can you do just Join instead of Inner Join to see where the mismatch is happening?
I used only (outer) join insted of inner join and the log file shows
BGRAD << 00-08000000-90-100-PA0008 25.063 Lines fetchedBGRAD 0 Lines fetchedmBGRAD << BGRAD 25.062 Lines fetched
Where is DATUM_SAP coming from? I am not seeing any script for that above?
this is the code:
Oh ya, I see it now in the initial post. Sorry I didn't realize it was already there. You might already be doing this, but are you creating this table before you do IntervalMatch, right?
yes at the very beginning... and actually it works with previous similar ApplyMaps ... only this one is "disobedient" 😁
see here an excerpt from the log file:
CAL << AUTOGENERATE(1) 70 Lines fetchedCAL << AUTOGENERATE(1) 71 Lines fetchedCAL << AUTOGENERATE(1) 72 Lines fetchedCAL-1 << 00-08000000-90-100-T528T (row-based qvd optimized) 8.752 Lines fetchedHRP1001 << 00-08000000-90-100-HRP1001 8.569 Lines fetchedHRP1001 311.680 Lines fetchedBASE << HRP1001 311.680 Lines fetchedmPER << BASE 123.163 Lines fetchedKST << 00-08000000-90-100-HRP1001 534 Lines fetchedKST 10.362 Lines fetchedmKST << KST 10.362 Lines fetchedBGRAD << 00-08000000-90-100-PA0008 25.063 Lines fetchedBGRAD 0 Lines fetchedmBGRAD << BGRAD 0 Lines fetched