topic Re: Join before concatenate? in QlikView

Join before concatenate?

Thu, 19 May 2016 10:43:31 GMT

Hello,

Is it possible to do a left join to a table before concatenating it to other data?

Let's say I have table A, B and C.

A contains fields 1,2,3

B contains fields 1,5,3

C contains fields 5,4

A is the first table to load

then I concatenate table B to it.

But what should I do, when I want to join C to B, before the concatenation happens to table A?

C contains real data for field 2 in table B in field 4.

Is this possible to do in QlikView?

My process at the moment is that

Load table A and Concatenate table B to it. But the left join is something that I need to table B.'

Any ideas?

Cheers,

Niko

Re: Join before concatenate?

sunny_talwar — Thu, 19 May 2016 10:47:18 GMT

I think you can do this:

LOAD 1,

From B;

Join (B)

LOAD 5,

FROM C;

Concatenate (B)

LOAD 1,

FROM A;

Alternatively, to the join you can also look into the possibility of making C a mapping load since in your example there are only two fields. But if there are more than 2, then going with the join might make sense

Re: Join before concatenate?

Kushal_Chawda — Thu, 19 May 2016 10:52:24 GMT

LOAD 1,

FROM Table B;

join(B)

LOAD 5,

FROM Table C;

LOAD 1,

FROM Table A;

Concatenate(A)

LOAD *

resident B;

drop table B;

Re: Join before concatenate?

jonas_rezende — Thu, 19 May 2016 13:58:36 GMT

Hi, Niko Suomi.

I recommend of reading the link https://www.resultdata.com/using-joins-in-qlikview/. Will facilitate the understanding about join and concatene.

Regards,

Jonas Melo.