Concatenating of two tables not working as expected

[vikasshana]

Hi,

I’ve two tables and combined two tables using concatenation, below is the script and output,

Table1:
Load Key2;

Concatenate(Table1)
Load Key1, [Key 2] as Key2

Output:

Key1      Key2
   A               C

   B                D

   E                 -
  
                       F

                        G

My required output is

Key1      Key2
   A               C

   B                D

    E                F

    E                G

Regards,

Vikas

[kaushiknsolanki]

Concatenate is working as expected. It will just append one table to another.

Your expectation is different and for that, you should "join", like left join (Table1).