Duplicate row in my model with concatenate

jmialoundama — Sat, 16 Nov 2024 19:07:11 GMT

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;

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.

Re: Duplicate row in my model with concatenate

jmialoundama — Thu, 13 Feb 2020 16:45:46 GMT

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.

topic Re: Duplicate row in my model with concatenate in App Development

Duplicate row in my model with concatenate

Re: Duplicate row in my model with concatenate