topic Re: Association and Joins in App Development

Association and Joins

AB108 — Thu, 18 May 2023 15:58:21 GMT

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.

Re: Association and Joins

Chanty4u — Thu, 18 May 2023 16:03:01 GMT

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

Re: Association and Joins

AB108 — Thu, 18 May 2023 16:35:39 GMT

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.

Re: Association and Joins

Vegar — Thu, 18 May 2023 17:06:05 GMT

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);