Row Count Differences: Join vs Concatenate vs NoConcatenate in Qlik

I have a dataset with 187 rows. Now, we can load the data into Qlik and check the result.

I have created two tables, Country_wise_latest and Country_wise_latest_1. Let’s check the output using a JOIN and Concatenate.

Tables

Lines are fetched — 374

Output

Join

Inner Join

Lines are fetched — 187

Output

• The change in line count before and after the JOIN is probably due to how Qlik matches records between the tables when joining them.
• Line Count = 374: When you load Country_wise_latest and Country_wise_latest_1 separately, Qlik fetches the rows from each table without merging them.
• Line Count = 187: An join keeps only the rows that have matching values in both tables. If both tables have the same data or rows with matching values in the join fields, Qlik will match each row and load it only once, giving 187 rows.

Concatenate

• With Concatenate, Qlik merges the rows from both tables into one, keeping all records and giving a final dataset with the total number of rows from both tables.

Concatenate

Lines are fetched — 374

Output

Example of Concatenate:

Example of Concatenate

Output

NoConcatenate

• When you use NoConcatenate, Qlik will treat the two tables as separate instead of merging them into one.

NoConcatenate

Data Model

Lines are fetched — 187

Output

Output