Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have repeating lines.
These are fake "duplicates".
Let me explain.
I run the following script:
Dim_Payable:
LOAD DISTINCT
K_ACCOUNT_PAYABLE_TAXES,
K_PAYABLE_RECEVABLE_TAXES
RESIDENT FACT;
LEFT JOIN(Dim_Payable)
LOAD
K_ACCOUNT_PAYABLE_TAXES,
"DOC PAY ITEM",
"ASOF",
"DATE",
"GL OFFSET",
"GL OFFSET LABEL",
RESIDENT FACT
where WildMatch(Flag_Fait,'F_ACCOUNT_PAYABLE')>0;
DROP FIELDS K_ACCOUNT_PAYABLE_TAXES FROM Dim_Payable;
Dim_Recevable:
LOAD distinct
K_ACCOUNT_RECEVABLE_TAXES,
K_PAYABLE_RECEVABLE_TAXES
RESIDENT FACT;
LEFT JOIN(Dim_Recevable)
LOAD
K_ACCOUNT_RECEVABLE_TAXES,
K_ACCOUNT_PAYABLE_TAXES,
"DOC PAY ITEM",
"ASOF",
"DATE",
"GL OFFSET",
"GL OFFSET LABEL",
RESIDENT FACT
where WildMatch(Flag_Fait,'F_ACCOUNT_RECEVABLE')>0;
DROP FIELDS K_ACCOUNT_RECEVABLE_TAXES FROM Dim_Recevable;
DROP FIELDS
"DOC PAY ITEM",
"ASOF",
"DATE",
"GL OFFSET",
"GL OFFSET LABEL",
FROM FACT;
Tmp_Dim_Payable_Recevable:
load * inline [
@
];
CONCATENATE(Tmp_Dim_Payable_Recevable)
LOAD * Resident Dim_Payable;
CONCATENATE(Tmp_Dim_Payable_Recevable)
LOAD * Resident Dim_Recevable;
DROP FIELD @ FROM Tmp_Dim_Payable_Recevable;
Drop table Dim_Payable;
Drop table Dim_Recevable;
Here is the result I get:
When I only run my first Dim_Payable table, I get the right visualization, this one:
Dim_Recevable:
LOAD distinct
K_ACCOUNT_RECEVABLE_TAXES,
K_PAYABLE_RECEVABLE_TAXES
RESIDENT FACT;
LEFT JOIN(Dim_Recevable)
LOAD
K_ACCOUNT_RECEVABLE_TAXES,
K_ACCOUNT_PAYABLE_TAXES,
"DOC PAY ITEM",
"ASOF",
"DATE",
"GL OFFSET",
"GL OFFSET LABEL",
RESIDENT FACT
where WildMatch(Flag_Fait,'F_ACCOUNT_RECEVABLE')>0;
DROP FIELDS K_ACCOUNT_RECEVABLE_TAXES FROM Dim_Recevable;
DROP FIELDS
"DOC PAY ITEM",
"ASOF",
"DATE",
"GL OFFSET",
"GL OFFSET LABEL",
FROM FACT;
But when I add my Dim_Recevable table and I just concatenate the two tables I get duplicate rows with empty data.
I try to do an outer join like that , at this moment of script :
Tmp_Dim_Payable_Recevable:
load * inline [
@
];
OUTER JOIN (Tmp_Dim_Payable_Recevable)
LOAD * Resident Dim_Payable;
OUTER JOIN (Tmp_Dim_Payable_Recevable)
LOAD * Resident Dim_Recevable;
DROP FIELD @ FROM Tmp_Dim_Payable_Recevable;
Drop table Dim_Payable;
Drop table Dim_Recevable;
But it's doesn't works.