Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
AJ_07
Contributor
Contributor

I want to add all the data that is in table 1 to table 2.

I want to add the two columns(say A & B) from Table 1 to Table 2. Both the tables have one same named column(KEY).Some values in KEY column are different . 

 

 

1 Reply
Or
MVP
MVP

Load * From Table2;

Concatenate

Load * From Table1;

This will create one table containing all of the values from both tables (values will not be joined, if identical keys existing they will remain as two separate rows).

If you're looking to join the values based on identical keys, you need to use Join instead of concatenate. As appropriate, you can use Left Join, Right Join, or Outer Join.

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/combine-tables-wi...