topic Re: Pull only specific field values in to table. in QlikView

Pull only specific field values in to table.

Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Pull only specific field values in to table.

maxgro — Tue, 11 Nov 2014 19:59:15 GMT

with match function

NewTeamList:

noconcatenate

load

Person, Team

resident

TeamList

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

;

drop table TeamList;

Re: Pull only specific field values in to table.

ashfaq_haseeb — Wed, 12 Nov 2014 06:46:34 GMT

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

Re: Pull only specific field values in to table.

Wed, 12 Nov 2014 07:07:42 GMT

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

Re: Pull only specific field values in to table.

Wed, 12 Nov 2014 07:24:38 GMT

Hi,

Table1:

Load *

From Tablename

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