Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I lose the columns
Supplier invoice and Date in my model when I try to concatenate two fact tables.
Here is my script:
Dim_Payable:
LOAD distinct
K_ACCOUNT_PAYABLE_TAXES & '-' & K_ACCOUNT_RECEVABLE_TAXES AS K_PAYABLE_RECEVABLE_TAXES,
K_ACCOUNT_PAYABLE_TAXES
RESIDENT FACT;
LEFT JOIN(Dim_Payable)
LOAD
K_ACCOUNT_PAYABLE_TAXES,
"SUPPLIOR INVOICE"
"POSTED",
"DATE",
"GL OFFSET",
"GL OFFSET LABEL",
"PAY STATUS CODE"
RESIDENT FACT
where WildMatch(Flag_Fait,'F_ACCOUNT_PAYABLE')>0;
DROP FIELD K_ACCOUNT_PAYABLE_TAXES FROM Dim_Payable;
Dim_Recevable:
LOAD distinct
K_ACCOUNT_PAYABLE_TAXES & '-' & K_ACCOUNT_RECEVABLE_TAXES AS K_PAYABLE_RECEVABLE_TAXES,
K_ACCOUNT_RECEVABLE_TAXES
RESIDENT FACT;
LEFT JOIN(Dim_Recevable)
LOAD
K_ACCOUNT_PAYABLE_TAXES,
"SUPPLIOR INVOICE"
"POSTED",
"DATE",
"GL OFFSET",
"GL OFFSET LABEL",
"PAY STATUS CODE"
RESIDENT FACT
where WildMatch(Flag_Fait,'F_ACCOUNT_RECEVABLE')>0;
DROP FIELD K_ACCOUNT_RECEVABLE_TAXES FROM Dim_Recevable;
Dim_Payable_recevable:
LOAD * Resident Dim_Payable;
CONCATENATE
LOAD * Resident Dim_Recevable;
Drop table Dim_Payable;
Drop table Dim_Recevable;
I don't understand where the problem is coming from. Why are my two columns not taken into account in my model?
Thanks for your feedback.
I understood why I was losing my DATE and SUPPLY INVOICE columns
run your script in parts (use exit script) and than check at which level these columns got missed
Thanks for your feedback.
I understood why I was losing my DATE and SUPPLY INVOICE columns