Lost colums when use concatenate

[jmialoundama]

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?

[Qlik1_User1]

run your script in parts (use exit script) and than check at which level these columns got missed

[jmialoundama · Accepted solution]

Thanks for your feedback.

I understood why I was losing my DATE and SUPPLY INVOICE columns