Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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 :

datepricecountry
1/1/20171France
1/1/20172Belgium
1/1/20173Germany
1/1/20174Netherlands

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.

1 Solution

Accepted Solutions
kenphamvn
Contributor III

Re: Create table from other loaded tables

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

3 Replies
shraddha_g
Honored Contributor III

Re: Create table from other loaded tables

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
Contributor III

Re: Create table from other loaded tables

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
Contributor III

Re: Create table from other loaded tables

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