Need help to connect table

[Anonymous]

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

[vishsaggi]

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

[Anonymous]

I need to Concatenate Table1 and Table 2 and get output

[Anil_Babu_Samineni]

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