In which scenario we use Lookup instead of ApplyMap

[qlikviewforum]

In which scenario we use Lookup instead of ApplyMap. Please provide the example for the same with some scenario.

[isorinrusu]

For lookup() you'd need to have the table previously loaded in your data model. But if you just need to map some field quickly from a table that's not in your data model, ApplyMap() is more practical since, even though you have to load the table, it will be dropped automatically. And it makes code easier to understand.

[jonathandienst]

ApplyMap() is usually faster and simpler than Lookup, and allows defined values for when a match is not made. So i would only use Lookup() if ApplyMap() was impractical. Although if the data was already loaded for some other reason, and the table was not too large, you could use Lookup() rather than reloading a mapping table for ApplyMap().