Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
mattphillip
Creator II
Creator II

Joining two large data tables

Dear Sir/Madam,

I have an extremely large data table loaded into Qlikview (14.5 million rows and 20+ columns - 4 years worth). We recently received this past year's data (2 million rows approx). Both are stored in Excel (.xlsx) and feature the same column names (with the odd exception). My problem is this, whilst typically I would open one of the excel table and simply add the data to the bottom, these tables are too large to open. Is there some way in the load script to join the content of the new table to the existing table's data?

Any help would be most appreciated.

Yours,

Matt

2 Replies
marcus_sommer

Have you tried to load these xlsx direct in qlikview and then storing them as txt-files or just using them as qvd which you then concatenate to your previous data.

- Marcus

jeckstein
Partner - Creator
Partner - Creator

If you want to merge 2 tables use a join condition.

So the syntax looks like

Table:

Load  ...

From  excelFile1 ;

Join(Table)

Load ...

From excelFile2 ;

In your case you would just use

Join("YOUR TABLE NAME HERE") and then add the fields you want.