Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasshana
Creator III
Creator III

Concatenating of two tables not working as expected

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

Labels (2)
1 Reply
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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).

 

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!