topic Re: Unable to join 2 tables --> Join issue in QlikView

Unable to join 2 tables --> Join issue

Thu, 26 Mar 2015 07:51:01 GMT

Dear All,

I have 2 tables like below

Table1:

LOAD USA,

REST,

DATE,

FROM

[Book1.xlsx]

(ooxml, embedded labels, table is Sheet1);

Table2:

LOAD PRODUCT,

REST,

DATE,

SALE

FROM

[Book1.xlsx]

(ooxml, embedded labels, table is Sheet2);

I made Join like below two merge columns from 2 tables into one table(FInal). But I'm unable to do that. I'm getting only first table columns. Pls help.

Final:

LOAD USA,

REST,

DATE,

resident Table1;

Join(Table1)

LOAD PRODUCT,

REST,

DATE,

SALE resident Table2;

BR,

Neeru

Re: Unable to join 2 tables --> Join issue

Thu, 26 Mar 2015 07:55:57 GMT

I figured out the small mistake.

Final:

LOAD USA,

REST,

DATE,

resident Table1;

Join(Final)

LOAD PRODUCT,

REST,

DATE,

SALE resident Table2;

Re: Unable to join 2 tables --> Join issue

mukesh24 — Thu, 26 Mar 2015 07:57:54 GMT

Hi Neeru,

Modify u r code as:-

1. u can directly join both table in level1 means instead of taking Resident load join table as :-

Table1:

LOAD USA,

REST,

DATE,

FROM

[Book1.xlsx]

(ooxml, embedded labels, table is Sheet1);

left join(Table1)

LOAD PRODUCT,

REST,

DATE,

SALE

FROM

[Book1.xlsx]

(ooxml, embedded labels, table is Sheet2);

2. In Resident load add Junk field as :-

Final:

LOAD USA,

REST,

DATE,

CR,

'x' as Junk

resident Table1;

Join(Final)

LOAD PRODUCT,

REST,

DATE,

SALE,

'y' as Junk

resident Table2;

Regards,

Mukesh

Re: Unable to join 2 tables --> Join issue

Thu, 26 Mar 2015 08:00:44 GMT

Hi,

You can use left join.

Final:

LOAD USA,

REST,

DATE,

resident Table1;

Left Join(Final)

LOAD PRODUCT,

REST,

DATE,

SALE resident Table2;