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

Pull only specific field values in to table.

Hi,

I have a table called TeamList

In it I have two fields, Person and Team.

There are multiple names under the Person field, but I only want hand picked 5 or 10 names, and bring it into the table.

How can I in the script limit the Person names to specific names like "Amy Smith" , "Bob Rubin", "Jon Mac" and so on..

Once pulled the table should only give me those names and team they are associated to.

Thanks,

Alam

1 Solution

Accepted Solutions
maxgro
MVP
MVP

with match function

NewTeamList:

noconcatenate

load

    Person, Team

resident

     TeamList

where match(Person,  'Amy Smith', 'Bob Rubin', 'Jon Mac')

     ;

drop table TeamList;

View solution in original post

4 Replies
maxgro
MVP
MVP

with match function

NewTeamList:

noconcatenate

load

    Person, Team

resident

     TeamList

where match(Person,  'Amy Smith', 'Bob Rubin', 'Jon Mac')

     ;

drop table TeamList;

ashfaq_haseeb
Champion III
Champion III

Hi,

Try like this

Temp:

load * Inline

[

Person,Team

Amy Smith,TeamA

Bob Rubin,TeamA

Jon Mac,TeamB

Nizam,TeamB

Amit,TeamC

Sam,TeamC

];

NoConcatenate

Main:

load

    *

resident Temp

where match(Person,'Amy Smith','Bob Rubin','Jon Mac');

DROP Table Temp;

Regards

ASHFAQ

Not applicable
Author

hi alam,

there are more than one way to do this.massimo and ashfaq have shown one way. another what you can do is

inline:

load * inline[

name

amy

bob

jon ];

load *

from teamlist where exists(name);

drop table inline;

or, after the inline load you can do

inner keep

load * from teamlist;

drop table inline;

do as you wish

cheers,

kunal  bhattacharjee

Not applicable
Author

Hi,

Table1:

Load *

       From Tablename

where match(Name, 'Amy Smith', 'Bob Rubin', 'Jon Mac') ;