topic Re: Need help to connect table in QlikView

Need help to connect table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Please help me to connect the below table, attached sample data

Re: Need help to connect table

vishsaggi — Tue, 20 Jun 2017 15:42:05 GMT

As your tables has same no and same field names autoconcatenation happens. Just load them like

LOAD ID,

Name

FROM

[..\Desktop\Test.xlsx]

(ooxml, embedded labels, table is Table1);

LOAD ID,

Name

FROM

[..\Desktop\Test.xlsx]

(ooxml, embedded labels, table is Table2);

LOAD ID,

Name

FROM

[..\Desktop\Test.xlsx]

(ooxml, embedded labels, table is Output);

Re: Need help to connect table

Anonymous — Tue, 20 Jun 2017 15:44:30 GMT

I need to Concatenate Table1 and Table 2 and get output

Re: Need help to connect table

Anil_Babu_Samineni — Tue, 20 Jun 2017 15:49:29 GMT

How about this?

LOAD ID,

Name

FROM

[Test.xlsx]

(ooxml, embedded labels, table is Table2) ;

Concatenate

LOAD ID,

Name

FROM

[Test.xlsx]

(ooxml, embedded labels, table is Table1) Where Not Exists(Name);