Unable to join 2 tables --> Join issue

[#1]

Dear All,

I have 2 tables like below

Table1:

LOAD USA,

     REST,

     DATE,

     CR

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,

     CR

resident Table1;

Join(Table1)

LOAD PRODUCT,

     REST,

     DATE,

     SALE resident Table2;

BR,

Neeru

[#2 · Accepted solution]

I figured out the small mistake.

Final:

LOAD USA,

     REST,

     DATE,

     CR

resident Table1;

Join(Final)

LOAD PRODUCT,

     REST,

     DATE,

     SALE resident Table2;

[mukesh24]

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,

     CR

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

[#4]

Hi,

You can use left join.

Final:

LOAD USA,

     REST,

     DATE,

     CR

resident Table1;

Left Join(Final)

LOAD PRODUCT,

     REST,

     DATE,

     SALE resident Table2;