Data Model

[ankit777]

Hi All,

While creating a data model for an application and joining various tables, what should be preffered, LOOKUP or JOINS?

Can I know the pros and cons of using JOIN as well as LOOKUP?

[MK_QSL]

If there are

only two fields in a table ==> use Apply Map and Mapping Load

4-5 fields in a table==> use look up

more than 5 fields ==> use join...

But it still depends on your data model and requirements .... also, the number of lines in any table... etc..

[ashfaq_haseeb]

Hi,

Please find the below post from henric, Explaning the same

http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/18/one-favorite-function-applymap

Hope it help.

Regards

ASHFAQ

[its_anandrjs]

Depends on the table nature and structure also it depends on the data model.

1. If there is unique key then use JOIN.

2. LOOKUP AND PEEK if want to load data from any location or read data or refer any field then use that one.

3. And free for all type of function.