Full Outer Join

[prabunakil]

Hi i have a scenario as per below, two source of data need to map and show as per screen shoot.

Please advise how i can load the script.

[prabunakil]

Hi Joseph

my above screenshoot i don think is a concatenate.

[prabunakil]

[rubenmarin]

Hi Prabu, when concatenating tables, fields with the same name are added to he previus ones, fields with new nemaes are created, giving Null() value to the row that comes from tables without that fields, so:

LOAD Material,

     Batch as [Combine Batch],

     Qty

From Source1;

Concatenate

LOAD Material,

     [3PL Batch] as [Combine Batch],

     [3PL Qty]

From Source2;

[jobsonkjoseph]

Dear Prabu,

This will work,

tab1:

LOAD Material,

     Batch as [Combine Batch],

     Qty

FROM

Community\join\Book1.xlsx

(ooxml, embedded labels, table is Sheet1);

Join

tab2:

LOAD Material,

     [3PL Batch] as [Combine Batch],

     [3PL Qty]

FROM

Community\join\Book1.xlsx

(ooxml, embedded labels, table is Sheet2);

[vitaliichupryna · Accepted solution]

Hi Prabu,

See example in attachment.

Concatenate works fine, but you need to add

0 AS [3PL Qty] to the first source table and

0 AS [Qty] to the second table

Thanks,

Vitalii

[prabunakil]

is working now., thank you very much/