Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hi Prabu, that looks like concatenation, not a join:
TableName:
Load * From source1;
Concatenate LOAD * From Source2;
But both source header row is different naming.
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.
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;
Source1:
LOAD
*,
Batch as [Combined Batch]
FROM ....;
Concatenate(Source1)
LOAD
*,
[3PL Batch] as [Combined Batch]
FROM ....;
When tables with same field names are loaded, auto concatenation happens.
I think you are not sharing the correct table field names.
sorry should be like this.
Ruben reply is correct, it'll get the required result Prabhu.