topic Re: qlkview in QlikView

qlikview - joins & concatenate

dinesh999 — Sat, 16 Nov 2024 03:10:06 GMT

difference b/w joins & concatenate?

Vegar — Thu, 27 Jun 2019 08:43:25 GMT

In short.

LOAD A, B, C FROM Table1;

JOIN LOAD A, B, D, E FROM Table2;

With join you are doing a lookup on common field names and values and where these match you add the unique columns where the values match.

LOAD A, B, C FROM Table1;

CONCATENATE LOAD A, B, D, E FROM Table2;

With Concatenate you just add new rows to the concatenated table.

Vegar — Thu, 27 Jun 2019 08:47:05 GMT

Channa — Thu, 27 Jun 2019 22:56:39 GMT

concatenate will do the union of two or many tables

join do join

Brett_Bleess — Wed, 24 Jul 2019 12:23:55 GMT

Let's see if we can get some further links on here for you and others to look over that may help!

Design Blog posts:

Help links:

I think that about covers it, hopefully this gets you what you need if you are still trying to sort things out here.

Regards,
Brett