Left join with Qualify in QlikView

[lawrance]

Hi,

Please give me solution for this problem.

b:

LOAD ID,

     Category,

     group

FROM

(ooxml, embedded labels, table is Sheet2);

QUALIFY*;

a:

LOAD ID,

     Name

FROM

(ooxml, embedded labels, table is Sheet1);

Left join (a)

LOAD * Resident b;

Actual Output:

a.ID,

a.Name

b-1.Category

b-1.group

Expected Output:

a.ID

a.Name

a.Category

a.group

Thanks,

Lawrance. A

[sunny_talwar · Accepted solution]

May be try like this:

Temp_a:

LOAD ID,

     Name

FROM

(ooxml, embedded labels, table is Sheet1);

Left join (Temp_a)

LOAD ID,

     Category,

     group

FROM

(ooxml, embedded labels, table is Sheet2);

QUALIFY *;

a:

NoConcatenate

LOAD *

Resident Temp_a;

DROP TABLE Temp_a;

[its_anandrjs]

Try this ways

b:

LOAD ID,

     Category,

     group

FROM

(ooxml, embedded labels, table is Sheet2);

QUALIFY*;

Unqualify ID;

a:

LOAD ID,

     Name

FROM

(ooxml, embedded labels, table is Sheet1);

Left join (a)

LOAD * Resident b;

Regards

Anand

[lawrance]

Thanks Sunny T

[its_anandrjs]

Or May be this also

b:

LOAD ID,

     Category,

     group

FROM

(ooxml, embedded labels, table is Sheet2);

QUALIFY*;

Unqualify ID;

a:

LOAD ID,

     Name

FROM

(ooxml, embedded labels, table is Sheet1);

Left join (a)

LOAD * Resident b;

Rename ID to a.ID;

Regards

Anand

[mikecrengland]

or...

QUALIFY*;

a:

LOAD ID,

     Name

FROM

(ooxml, embedded labels, table is Sheet1);

Left join (a)

UNQUALIFY *;

LOAD ID AS a.ID,

     Category AS a.Category,

     group AS a.group

FROM

(ooxml, embedded labels, table is Sheet2);