1 Reply Latest reply: Nov 22, 2017 8:40 AM by Mark Little RSS

    Synthetic keys - removal

    Munetsi Danga

      Hi Community

       

      I have a model whose models eventually looks like this


            

      GLE:

      LOAD Y, RC, BU, GEEWE

      FROM ***

      (ooxml, embedded labels, table is GLE);

       

      ILE:

      LOAD Y, RC, BU, ILEWE

      FROM ***

      (ooxml, embedded labels, table is ILE);

       

      BE:

      LOAD Y, RC, BU, BEWE

      FROM ***

      (ooxml, embedded labels, table is BE);

       

       

      And the tables are like

       

                

      skeys.JPG

      The model was giving the expected results until now.

      I need to get rid of the synthetic keys


      May you please help by way of an example with a simple LOAD inline

        • Re: Synthetic keys - removal
          Mark Little

          HI,

           

          Hard to give the correct advised not knowing what the data is, assuming that the field contain the same data i would approach like the below.

           

          GLE:

          LOAD

          'GLE'     AS Type,

          Y,

          RC,

          BU,

          GEEWE

          FROM ***

          (ooxml, embedded labels, table is GLE);

           

          Concatenate

           

          ILE:

          LOAD

          'ILE'      As TYPE

          Y,

          RC,

          BU,

          ILEWE

          FROM ***

          (ooxml, embedded labels, table is ILE);

           

          Concatente

           

          BE:

          LOAD

          BE As Type,

          Y,

          RC,

          BU,

          BEWE

          FROM ***

          (ooxml, embedded labels, table is BE);

           

          This will give you one fact table with a type to restrict the information to the source table.

          If this is not what you are after then you will need to alias all the field in the table that are not the Key.

           

          Mark