Merging Tables Vertically

[rds694]

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;

[vinieme12]

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;