Create table from other loaded tables

[#1]

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.

[shraddha_g]

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];

[kenphamvn · Accepted solution]

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];

Loading data from a previously loaded table ‒ Qlik Sense

[pathiqvd]

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];