Lookup() vs. Join Performance, ApplyMap() vs. Inner Join

[acarrera]

Hi all,

I am replacing some Joins with ApplyMap() and (potentially) Lookup() in a Qlik Sense script.

Two questions:

1. I know ApplyMap() is faster than Lookup() and joining, but is Lookup() faster than a join too?
2. Can I use ApplyMap() with Where Exists() to simulate an inner join?

Thanks,

Alex

[rwunderlich · Accepted solution]

Lookup is likely the slowest option. See https://qlikviewcookbook.com/2020/03/creating-temporary-script-associations/.

Yes, you can use ApplyMap with Where Exists to replace an inner join. 

-Rob

[acarrera]

Great, thanks Rob for your prompt and informative reply!

Best,

Alex