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.

[rubenmarin]

Hi Prabu, that looks like  concatenation, not a join:

TableName:

Load * From source1;

Concatenate LOAD * From Source2;

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes...

[prabunakil]

But both source header row is different naming.

[niclaz79]

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.

[prabunakil]

[rubenmarin]

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;

[niclaz79]

Source1:

LOAD

     *,

     Batch as [Combined Batch]

FROM ....;

Concatenate(Source1)

LOAD

     *,

     [3PL Batch] as [Combined Batch]

FROM ....;

[jobsonkjoseph]

When tables with same field names are loaded, auto concatenation happens.

I think you are not sharing the correct table field names.

[prabunakil]

sorry should be like this.

[jobsonkjoseph]

Ruben reply is correct, it'll get the required result Prabhu.