Qlik Community

Third-Party Qlik Jobs

Area for people to learn more about current Qlik related job postings.

Highlighted
dolly777
New Contributor III

I have 2 dimension table 1 fact table i need to join 3 tables?

Hi All,

 How to joining 3 table have same field in common

Exm:

Table 1:

load
Cust_id,
Cust_Key,
Version,
Ins_date

Table 2:

load
Prod_id
Prod_Key ,
Version,
Ins_date

Table 3: (fact table)

load
Prod_id,
Report,
Cust_id,
Report_id,
Version,
Ins_date

1 Reply
MVP
MVP

Re: I have 2 dimension table 1 fact table i need to join 3 tables?

No, there is no need to join the tables. Do you really need the Version and Ins_date fields in your model, they look like audit fields only? If not, simply remove them from your load script.

If you do really need them, then add a qualify:

Qualify Version, Ins_date;

... your script as posted in your question (unchanged) ...

UnQualify *;
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein