Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

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
MVP
MVP

Re: Pull only specific field values in to table.

with match function

NewTeamList:

noconcatenate

load

    Person, Team

resident

     TeamList

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

     ;

drop table TeamList;

4 Replies
MVP
MVP

Re: Pull only specific field values in to table.

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.

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

Re: Pull only specific field values in to table.

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

Re: Pull only specific field values in to table.

Hi,

Table1:

Load *

       From Tablename

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