3 Replies Latest reply: Sep 11, 2017 5:42 AM by lakshmipathi p RSS

    Create table from other loaded tables

    Eleyeh Abaneh

      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.