18 Replies Latest reply: Nov 29, 2017 6:26 AM by omar bensalem RSS

    Outher join and keep table

    Livio Sebastiano Colombo

      Hi everyone,

      I have a problem with the join.

      I would like to execute a join between 3 tables and keep the result table for reporting.

       

      [MAP PRODUCT HFM 2017]:

      LOAD

      [HFM CODE] AS [HFM CODE-HFMCode],

      [DESCRIPTION],

      [Plant abbr],

      ....

      FROM lib...

      (ooxml, embedded labels, header is 1 lines, table is [MAP PRODUCT HFM 2017]);

       

       

      [MAP MARKET 2017]:

      LOAD

      [Market Code] AS [Market-Market Code],

      [REGION] AS [Plant_Region-REGION],

      ...

      FROM lib...

      (ooxml, embedded labels, header is 1 lines, table is [MAP MARKET 2017]);

       

       

      [MAP BRAND 2017]:

      LOAD

      [Scenario] AS [MAP BRAND 2017.Scenario],

      [Format],

      [Years],

      ...

      FROM lib...

      (ooxml, embedded labels, header is 1 lines, table is [MAP BRAND 2017]);

       

       

      [HFM DB]:

      LOAD

      [Year],

      [Scenario] AS [HFM DB.Scenario],

      [Month] AS [HFM DB.Month],

      [Brand],

      ...

      FROM lib...

      (ooxml, embedded labels, header is 1 lines, table is [HFM DB]);

       

       

      I'd like to execute an outher join:

      HFM DB with MAP MARKET 2017 by MARKET CODE

      HFM DB with MAP PRODUCT HFM 2017 by HFM CODE

      HFM DB with MAP BRAND 2017 by BRAND



      At last I'd like to keep the result table from this outher join.



      Thanks in advantage,

      Livio