Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
with match function
NewTeamList:
noconcatenate
load
Person, Team
resident
TeamList
where match(Person, 'Amy Smith', 'Bob Rubin', 'Jon Mac')
;
drop table TeamList;
with match function
NewTeamList:
noconcatenate
load
Person, Team
resident
TeamList
where match(Person, 'Amy Smith', 'Bob Rubin', 'Jon Mac')
;
drop table TeamList;
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
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
Hi,
Table1:
Load *
From Tablename
where match(Name, 'Amy Smith', 'Bob Rubin', 'Jon Mac') ;