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: 
Not applicable

loading required data

hi all,

I have 7 fields in my table and one of the field is client_id. I have 10 clients.

i want to load only data from all 7 fields of particular 5 clients.

anyone help to get it.

Thanks,

Pramod

1 Solution

Accepted Solutions
jsanchezh
Partner - Creator
Partner - Creator

You can add the WHERE clause after the FROM clause on the script

Load * fields

From [directory]

Where client_id='name_client1' and client_id='name_client2' and client_id='name_client3'...



View solution in original post

6 Replies
maxgro
MVP
MVP

load

     *

from

     yourtable

where

     match(client_id, 'firstclientvalue', 'secondclientvalue')     // add other 3 values, maybe remove quote

    

Anonymous
Not applicable
Author

Use "where" clause:

SELECT

client_id,

...

field7

FROM Table

WHERE client_id <meets some condition, or simply enumerated>

jsanchezh
Partner - Creator
Partner - Creator

You can add the WHERE clause after the FROM clause on the script

Load * fields

From [directory]

Where client_id='name_client1' and client_id='name_client2' and client_id='name_client3'...



maxgro
MVP
MVP

I think or

where .... or ..... or .....

Anonymous
Not applicable
Author

Certainly it is "or".  In this case, "and" will return no records at all.

And, if enumerate the values, it is cleaner with match().

jsanchezh
Partner - Creator
Partner - Creator

yes, that's right I made a mistake while writing it down (OR shall be the correct option)