Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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...