topic Re: Left join with Qualify in QlikView in QlikView

Left join with Qualify in QlikView

lawrance — Thu, 15 Dec 2016 19:38:14 GMT

Hi,

Please give me solution for this problem.

LOAD ID,

Category,

group

FROM

(ooxml, embedded labels, table is Sheet2);

QUALIFY*;

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

Re: Left join with Qualify in QlikView

sunny_talwar — Thu, 15 Dec 2016 19:43:03 GMT

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 *;

NoConcatenate

LOAD *

Resident Temp_a;

DROP TABLE Temp_a;

Re: Left join with Qualify in QlikView

its_anandrjs — Thu, 15 Dec 2016 19:45:40 GMT

Try this ways

LOAD ID,

Category,

group

FROM

(ooxml, embedded labels, table is Sheet2);

QUALIFY*;

Unqualify ID;

LOAD ID,

Name

FROM

(ooxml, embedded labels, table is Sheet1);

Left join (a)

LOAD * Resident b;

Regards

Anand

Re: Left join with Qualify in QlikView

lawrance — Thu, 15 Dec 2016 19:47:36 GMT

Thanks Sunny T

Re: Left join with Qualify in QlikView

its_anandrjs — Thu, 15 Dec 2016 19:48:22 GMT

Or May be this also

LOAD ID,

Category,

group

FROM

(ooxml, embedded labels, table is Sheet2);

QUALIFY*;

Unqualify ID;

LOAD ID,

Name

FROM

(ooxml, embedded labels, table is Sheet1);

Left join (a)

LOAD * Resident b;

Rename ID to a.ID;

Regards

Anand

Re: Left join with Qualify in QlikView

mikecrengland — Thu, 15 Dec 2016 20:38:17 GMT

or...

QUALIFY*;

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);