Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mapratt82
Creator
Creator

Data Load Issue

I'm trying to load the following, it doesn't give an error, but it says 0 lines fetched. Please help. Thanks.

[CustomerTable]:
LIB CONNECT TO [QlikSQL (cbsbank_mpratt)];
LOAD
[Name_ID],
[Account_Number],
    [Closed_Acct_Flag],
    [Document_Distribution_Group];


SQL SELECT 
t0.Name_ID,
t0.Account_Number,
t1.COD_Account,
t1.Closed_Acct_Flag,
t1.Document_Distribution_Group,
t2.DDA_Account,
t2.Closed_Acct_Flag,
t2.Document_Distribution_Group,
t3.Note_Number,
t3.Closed_Account_Flag as [Closed_Acct_Flag],
t3.Document_Distribution_Group,
t4.SAV_Account,
t4.Closed_Acct_Flag,
t4.Document_Distribution_Group

FROM
"WEEK"."dbo"."Name_To_All_Acct" as t0,
"WEEK"."dbo"."COD_Codes"        as t1,
"WEEK"."dbo"."DDA_Codes"        as t2,
"WEEK"."dbo"."Note_Codes"       as t3,
"WEEK"."dbo"."SAV_Codes"        as t4

WHERE t0.Account_Number       =  t1.COD_Account
and t0.Account_Number      =  t2.DDA_Account
and t0.Account_Number     =  t3.Note_Number
and t0.Account_Number     = t4.SAV_Account;

5 Replies
sunny_talwar

Have you tried running your SQL outside QlikView to check if any data is matches your Where statement to show any data?

mapratt82
Creator
Creator
Author

I really don't have a way to run it outside of Qlik. I do know that Account_Number and the others are the same. Basically Name_To_All_Acct is a relational table that relates the name table to the different account type tables. So there must be something wrong in the way I'm trying to pull this, because it should be pulling data. Good thought though, Thanks.

ziadm
Specialist
Specialist

Hi

check if you have set set ErrorMode=0 then make to 1

ErrorMode=1

mapratt82
Creator
Creator
Author

Not sure on what the ErrorMode is and how to change it. I do know I took out all but the Name_To_All_Acct and COD_Codes and loaded it and got back 50k+  lines. I then added DDA_Codes to the other 2 and got back only around 200 lines. I'm not sure the logic is right to get multiple tables to load/link the same fields.

maxgro
MVP
MVP

start with 1 table

SQL SELECT 

t0.Name_ID,

t0.Account_Number

FROM

"WEEK"."dbo"."Name_To_All_Acct" as t0


How many lines fetched?

Then add the 2nd one in the from and in the where


............

FROM

"WEEK"."dbo"."Name_To_All_Acct" as t0,

"WEEK"."dbo"."COD_Codes"        as t1

WHERE t0.Account_Number       =  t1.COD_Account

How many lines fetched?

Then add the 3rd one in the from and in the where

etc.. etc....