Association and Joins

[AB108]

HI,

I am associating two tables on 3 fields. Out of these for one field I want it to mimic an inner join.

The tables are huge and at diff levels so I want to avoid joins. What could be the best way to achieve this.

[Chanty4u]

Hi 

you can use the "Concatenate" function to mimic an inner join on a specific field in Qlik Sense

[AB108]

Hi @Chanty4u, I want association to mimic inner join only on one associated field. For others I still want simple association(outerjoin).

Can you give an example.

[Vegar]

The script below will give you a three field association (outer join) between A, B, C; and it will also mimic a left join on field A as we exclude any rows on table2 without match on field A in table1 to be excluded.

Load A, B, C, D,E From Table1;

Load A, B, C, X, Y, Z From Table2 where Exists (A);