
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Create table from other loaded tables
Hi,
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 :
LOAD date,
'France' as country,
[price] as FR_prices;
[FR_prices]:
SELECT "date",
"price"
FROM "public"."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 :
date | price | country |
---|---|---|
1/1/2017 | 1 | France |
1/1/2017 | 2 | Belgium |
1/1/2017 | 3 | Germany |
1/1/2017 | 4 | Netherlands |
I have tried :
[countries_prices]:
Load BE_prices
FROM [BE_prices];
Left Join ([countries_prices])
Load NL_prices
FROM [NL_prices];
Left Join ([countries_prices])
Load FR_prices
FROM [FR_prices];
Left Join ([countries_prices])
Load DE_prices
FROM [DE_prices];
But it gets me errors in the load editor.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
if you want to loading data from a previously loaded table, please replace 'FROM' keyword by 'RESIDENT'
Example
[countries_prices]:
Load BE_prices
FROM [BE_prices];
==>
[countries_prices]:
Load BE_prices
Resident [BE_prices];

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try:
[countries_prices]:
Load BE_prices as Price,
Country,Date
FROM [BE_prices];
Concatenate
Load NL_prices as Price,
Country,Date
FROM [NL_prices];
Concatenate
Load FR_prices as Price,
Country,Date
FROM [FR_prices];
Concatenate
Load DE_prices as Price,
Country,Date
FROM [DE_prices];

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
if you want to loading data from a previously loaded table, please replace 'FROM' keyword by 'RESIDENT'
Example
[countries_prices]:
Load BE_prices
FROM [BE_prices];
==>
[countries_prices]:
Load BE_prices
Resident [BE_prices];


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
[countries_prices]:
Load BE_prices
Resident [BE_prices];
Left Join ([countries_prices])
Load NL_prices
Resident [NL_prices];
Left Join ([countries_prices])
Load FR_prices
Resident [FR_prices];
Left Join ([countries_prices])
Load DE_prices
Resident [DE_prices];
