Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
try this
qualify * ;
Unqulify BudgetKey;
Load
BudgetKey,
BudgetYear,
BudgetQuarter,
Budgetholder
Resident Budget;
Unqualify*;
try this
qualify * ;
Unqulify BudgetKey;
Load
BudgetKey,
BudgetYear,
BudgetQuarter,
Budgetholder
Resident Budget;
Unqualify*;
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