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: 
sculptorlv
Creator III
Creator III

Massive??

Hello again!

I have another "situation for a junior". Hope for help and advises.

I have a sql table, like:

SQL SELECT

ID

Name

Age

etc...

FROM Table

WHERE

Name <> Name1

Name <> Name2

..

Name <> Name50

What is the best practice to define these WHERE expressions? Is it possible to make a massive of all possible "Names", which I will not take in my SQL Select? Also, it might be more comfortable to change and massive rather WHERE expressions..

19 Replies
Anonymous
Not applicable

Hi,

You can define all the names which you want to exclude in an excel file, and load that excel in script under one resident,

later use where not exist functionality to exclude.

sculptorlv
Creator III
Creator III
Author

Got error:

1.jpg

tresesco
MVP
MVP

WHERE

RTrim(LTrim(Tbl_Contract.Title)) Not In ($(vFriendCompnayList));

?

sculptorlv
Creator III
Creator III
Author

Now it works, but the result is the same.

VENDEN KAFIJAS TIRDZNIECĪBA is within the data

tresesco
MVP
MVP

Somehow the string is not matching. Try the same in the sql db itself (with the single value). Does it work? Find the exact match in the db itself for that particular title and copy paste it from there to qv. It should work.

sculptorlv
Creator III
Creator III
Author

For no I use Where name <> Name1 AND name <> Name2 ... it works.

sculptorlv
Creator III
Creator III
Author

How to make an exclude?

Anonymous
Not applicable

using where not exists(FieldName)

reddy-s
Master II
Master II

Hi Ruslans,

Where not Exists() should solve your issue.

Check this out:

The exists issue

sculptorlv
Creator III
Creator III
Author

Sorry, I don't get it.

I don't need these 'a' values at all, but in the example it got ONE 'a' values from two tables.