Discussion board where members can get started with Qlik Sense.
I am a very new Qlik user and I encounter troubles with JOIN and RESIDENT functions
I have four tables loaded from a database. The tables are loaded this way :
'France' as country,
[price] as FR_prices;
The three others tables are for Belgium, Netherlands and Germany. They are loaded in a similar way (you replace FR by BE,NL or DE and France by the corresponding country).
I want now to create a new table from all those four tables. This table named [countries_prices] should be like :
I have tried :
Left Join ([countries_prices])
But it gets me errors in the load editor.
Go to Solution.
if you want to loading data from a previously loaded table, please replace 'FROM' keyword by 'RESIDENT'
Loading data from a previously loaded table ‒ Qlik Sense
Load BE_prices as Price,
Load NL_prices as Price,
Load FR_prices as Price,
Load DE_prices as Price,