Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
jmialoundama
Specialist
Specialist

Lost colums when use concatenate

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?

 

 

 

Labels (4)
1 Solution

Accepted Solutions
jmialoundama
Specialist
Specialist
Author

Thanks for your feedback.

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

View solution in original post

2 Replies
Qlik1_User1
Specialist
Specialist

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

jmialoundama
Specialist
Specialist
Author

Thanks for your feedback.

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