3 Replies Latest reply: Sep 29, 2011 8:06 AM by Michiel van de Goor RSS

    Link table results in synthetic key

    Michiel van de Goor

      Hi,

      I created this script but it doesn't result in a link table but it results in a synthetic key.

      I don't understand why.

      The content of the fields are exactly the same.

       

      Thanks for you help.

       

      Script:

       

      LinkTable:

      load Distinct

          BudgetKey,

          year(AddMonths(OrderDate, $(vFiscalOffset))) as BudgetYear,

          ceil(month(AddMonths(OrderDate, $(vFiscalOffset)))/3) as BudgetQuarter,

          if(EmployeeBusinessEntityID = 'Website', -1, num#(EmployeeBusinessEntityID)) as Budgetholder

      Resident SalesOrders2;

       

      Concatenate (LinkTable)

      load Distinct

          BudgetKey,

          BudgetYear,

          BudgetQuarter,   

          Budgetholder

      Resident Budgets;