Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
How to join the two report ?
The 'Supplementary' needs to be added in the Customer field with log fees -5981844.
Chart 1.
Sample Model attached.
why not concatenate your Fact table and Supplementary table keeping the fields name same for common fiel
like Cust should be Customer in both table and provision should be Logistics_fee
why not concatenate your Fact table and Supplementary table keeping the fields name same for common fiel
like Cust should be Customer in both table and provision should be Logistics_fee
You have synthetic keys in your model. You have product_key as your key field that joins with other tables.
Can you try like renaming your product code in supplementary table like below and re run your script.
SELECT
[period_key]
,'Supplementary' as Cust
// ,'Supplementary Customer' AS [Customer Code Name]
,[Product Code] AS Suppl_product_code
......
FROM ..... ;
Can you try like this:
TableA:
Load Brand,
ProductCode,
Product,
Customer,
LogFees;
Concatenate
TableB:
Load
Cust as Customer,
Provision as LogFees;