topic Re: Table Join Question in QlikView

Table Join Question

Thu, 30 Jun 2011 20:05:13 GMT

I have table A which has about 20 columns. Table B is a small table with 4 columns. I need to match the first 3 columns in table B to the same 3 values in table A. I then need to add the last column in table B to table A. Please see the below code, I get an error when running this code. Before this statement is executed both table A and B are loaded.

Left Join ()

LOAD [A1],

[A2],

[A3],

[B4]

Resident

Where [A1] = [B1]

and [A2] = [B2]

and [A3] = [B3];

Table Join Question

Thu, 30 Jun 2011 20:26:25 GMT

Hi,

When joined tablesyou need to concatenate the keys.

Ex.:

Tab_A:

A1 & '#' & A2 & '#' &A3 AS KEY_TABLE_A

...

A40

FROM MY_TABLE_A;

LEFT JOIN (Tab_A)

Tab_B:

B1 & '#' & B2 & '#' & B3 AS KEY_TABLE_A

FROM MY_TABLE_B;

Re: Table Join Question

nagaiank — Thu, 30 Jun 2011 20:27:18 GMT

Please try the following script

Left Join ()

LOAD [A1],

[A2],

[A3],

[B4]

Resident ;

Where [A1] = [B1]

and [A2] = [B2]

and [A3] = [B3];