Link table results in synthetic key

[Michiel_QV_Fan]

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;

[SunilChauhan · Accepted solution]

try this

qualify * ;

Unqulify BudgetKey;

Load

BudgetKey,

    BudgetYear,

    BudgetQuarter,   

    Budgetholder

Resident Budget;

Unqualify*;

[its_anandrjs]

Hi,

You have to link it with Budgetholder so unqualify Budgetholder  and reset of tables qualify

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;

qualify * ;

Unqulify Budgetholder;

Load

BudgetKey,

    BudgetYear,

    BudgetQuarter,  

    Budgetholder

Resident Budget;

Unqualify*;

Rgds

Anand

[Michiel_QV_Fan]

its.anandrjs answer:

This resulted in 2 synthetic keys.

Despite that, thanks for the help