1 Reply Latest reply: Apr 10, 2018 10:17 AM by Bill Markham RSS

    syn key remove

    sony sing

      hi all,

       

      I have one table with columns like below

      A:

      Id,

      cost,

      item,

      Engineer

      Programmer              these two having the  values  ID's

       

      and I have a master table to map this

      mst_group:

      "UserID" as Engineer,

          "UserID" as Programmer,

             UserName

       

      from  qvd;

       

       

      when I load this am getting  synthetic key   how can I resolve this?

       

      here in master table  all user names belongs to eng and prog are there.

       

       

      Thanks

        • Re: syn key remove
          Bill Markham

          Try a Mapping Load and then ApplyMap(), maybe something like but I not sure I have properly understood your underlying data and I have typed the below free hand so it may have typo's.

           

          MapUserName :

          Mapping Load

              [UserID] ,

              [UserName]

          from  qvd;

           

           

          A:

          Id,

          cost,

          item,

          ApplyMap ( 'MapUserName' , [Engineer]        , null() )  as [Engineer Name] ,

          ApplyMap ( 'MapUserName' , [Programmer]  , null() )  as [Programmer Name]

          from ..............