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: 
tan_chungkam
Creator
Creator

Where Statement

Hi Lads,

I have table which has several company codes.

I would like to load only 300 and 310.

However it doesn't work.

Please find my scripting in the attachment and screenshot.

image.pngMy data sourceMy data source

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hi 

just change your script 

replace the "and" with "or" in the where statement

View solution in original post

2 Replies
lironbaram
Partner - Master III
Partner - Master III

hi 

just change your script 

replace the "and" with "or" in the where statement

tan_chungkam
Creator
Creator
Author

@lironbaram ,

Thanks a million.

It works. It would be nice if you explain why we can't use 'And'?

The reason i found another way to do that which is the script below.  And I'm using 'And' instead of 'Or'.

image.png