Join before concatenate?

[#1]

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

[sunny_talwar]

I think you can do this:

B:

LOAD 1,

          5,

          3

From B;

Join (B)

LOAD 5,

          4

FROM C;

Concatenate (B)

LOAD 1,

          2,

          3

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

[Kushal_Chawda]

B:

LOAD 1,

          5,

          3

FROM Table B;

join(B)

LOAD 5,

           4

FROM Table C;

A:

LOAD 1,

          2,

           3

FROM Table A;

Concatenate(A)

LOAD *

resident B;

drop table B;

[jonas_rezende]

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.