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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
rds694
Contributor
Contributor

Merging Tables Vertically

Hi all, I'm trying to figure out how to merge two tables vertically in the Data load editor, but it's not working. Basically I have two tables and I want to just combine all the rows into one big table.

When I try to do it, the it alters the data in the first table, with data from the 2nd one. Any thoughts on how to do this?

 


[Group2QualitativeData]:
CrossTable(Group2Field, Group2Response, 1)
LOAD
trim([ID]) as [ID]

.

.

.

 

[Group2]:
CrossTable(QualitativeData, Group2Response, 2)
Load
trim([ID]) as [ID],

.

.

.

Concatenate
Load * Resident Group2QualitativeData;

Labels (2)
1 Reply
vinieme12
Champion III
Champion III

Always specify explicitly which table should be concatenated with or joined with

Concatenate(TABLENAME)

Left Join (TABLENAME)

 

[Group2QualitativeData]:
CrossTable(Group2Field, Group2Response, 1)
LOAD
trim([ID]) as [ID]
From SomeSource;


[Group2]:
CrossTable(QualitativeData, Group2Response, 2)
Load
trim([ID]) as [ID],
From Xyzsource;

Concatenate(Group2)
Load * Resident Group2QualitativeData;
Drop Table Group2QualitativeData;

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.