
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Full Outer Join
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.
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Prabu, that looks like concatenation, not a join:
TableName:
Load * From source1;
Concatenate LOAD * From Source2;

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
But both source header row is different naming.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
In your picture the column names are all the same, not sure what you mean.
Otherwise just rename the columns in your sources to be the same.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can use 'as' to remane column names:
LOAD Material,
Batch as [Combine Batch],
Qty
From Source1;
Concatenate
LOAD Material,
[3PL Batch] as [Combine Batch],
Qty
From Source2;


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Source1:
LOAD
*,
Batch as [Combined Batch]
FROM ....;
Concatenate(Source1)
LOAD
*,
[3PL Batch] as [Combined Batch]
FROM ....;

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
When tables with same field names are loaded, auto concatenation happens.
I think you are not sharing the correct table field names.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
sorry should be like this.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Ruben reply is correct, it'll get the required result Prabhu.

- « Previous Replies
-
- 1
- 2
- Next Replies »