Inner Join Issue

[jerryr125]

Hi -
I am attempting an Inner Join function.
I have two tables and the end result I am attemping to achieve is for a table (IDFINALDATA)
consisting of ONLY the records in both CPSDATA and IDPREDATA.
For example, if there is 10,000 records in IDPREDATA and only 2,000 match to records in CPSDATA (FieldCP03)
then IDFINALDATA should consist of 2,000 records.

I am getting an error message "Table IDFINALDATA not found".
Any thoughts on the below ??

CPSDATA:
LOAD
FieldCP01,
FieldCP02,
FieldCP03
FROM excel file;

IDPREDATA:
LOAD
FieldA as IDPREFieldA,
FieldB as IDPREFieldB,
FieldC as IDPREFieldC,
FieldD as FieldCP03
Resident IDSTARTDATA;

Drop Table IDSTARTDATA;

IDFINALDATA:
LOAD *
Resident IDPREDATA;
Inner Join (IDPREDATA)
LOAD *
Resident [CTCSDATA];

[Vegar · Accepted solution]

You are experiencing Autoconcatenate. Try this as your final.

IDFINALDATA:
NoConcatenate LOAD *
Resident IDPREDATA;
Inner Join (IDPREDATA)
LOAD *
Resident [CTCSDATA];

Drop table IDPREDATA;

Read this on concatenation: https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/LoadData/concatenate...

[jerryr125]

Perfect ! Thank you !