Issue while using the WHERE clause in LOAD Statement!

[#1]

Hi All,

I am facing problem in using WHERE clause in a LOAD statement. I am getting the below error while using this LOAD statement. Hope some one can help me out.

SecurityTable:
LOAD DISTINCT
 'USER' as [ACCESS],
 upper([userid]) as [USERID],
 upper([password]) as [PASSWORD],
 upper(mfaccode) as SecurityMfa,
 'Some' as SecurityPage
resident TempTab where userid not in('001001admin','001001vadmin');

CONCATENATE (SecurityTable)
LOAD DISTINCT
 'USER' as [ACCESS],
 upper([userid]) as [USERID],
 upper([password]) as [PASSWORD],
 upper(mfaccode) as SecurityAccount,
 '*' as SecurityMfa,
 'Some' as SecurityPage
resident TempTab where userid in('001001admin','001001vadmin');

Error:

Garbage after statement
SecurityTable:
LOAD DISTINCT
 'USER' as [ACCESS],
 upper([userid]) as [USERID],
 upper([password]) as [PASSWORD],
 upper(mfaccode) as SecurityMfa,
 'Some' as SecurityPage
resident TempTab where userid not in('001001admin','001001vadmin')

[#2]

Hello Rocky!

Thanks for your reply. Let me know which one you are talking about. There are many codes above.

Thanks and Regards,

Rikab

[#3]

I have had the same problem using WHERE field IN (x,y,z) and have used the above MATCH solution which seems to work well.

However, it's very frustrating because WHERE field IN (x,y,z) seems to work when connecting to source data via ODBC but doesn't work when pointing to a .qvd file.