Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Federicofkt
Contributor III
Contributor III

IntervalMatch not working

I'm trying to make IntervalMatch work in my script on Qlik Sense. I have other IntervalMatch and they are all working fine, but this last one keeps throwing an error.

 

My script:


Qualify *;
Unqualify 'key*';

NoConcatenate
Priorita:
LOAD *
Resident Priorita_temp_last
;

Unqualify *;

Call Anagrafica('Mandati','');

Left Join IntervalMatch ( Mandati.DataIns, Mandati.CU )
LOAD Priorita.ValiditaAl, Priorita.ValiditaDal, Priorita.CU
Resident Priorita;

 

The Call Anagrafica('Mandati',''); just calls a function that calls the specified table.

The error is that the columns Priorita.ValiditaAl, Priorita.ValiditaDal, Priorita.CU are not found.

I've tried with some debug to save the Priorita QVD and then exit the script in order to check if the columns are there, and they actually are, so I totally don't understand why it can't found them when using the IntervalMatch.

 

Thanks

Labels (2)
1 Reply
andrefpc
Partner - Creator II
Partner - Creator II

Try and create a dummy field on the load script after the left join, like:

Left Join IntervalMatch ( Mandati.DataIns, Mandati.CU )
LOAD Priorita.ValiditaAl, Priorita.ValiditaDal, Priorita.CU, 1 as dropfield
Resident Priorita;