Script

[smilingjohn]

Hi All

I have a field called Team, within the field name i have many contentes and among which i have to select those which has Iperformance ,

Please find the attachment .. can some one tell me how do i write in the script to get those Team which has iperformance in it .

and Iperformance

Regards ,

[vinieme12]

LOAD *

FROm XXXXXX

where wildmatch(Team,'*iperformance*')

[sunny_talwar]

Or

Where Team Like '*Iperformance*';

[smilingjohn]

Hi sunny ,

will this sort all that teams which has iPerformance ?

for example 303eiPerformance,201e iPerformanceXVDef, X5 iPerformance, ......and so on ?

[smilingjohn]

And also iam creating a flag and iam using this , if the content under field team is Iperformance then it should be 1 else 0 ,

is this correct iam  trying to use the flag ?

if(Team='*iperformance*',1,0) as iPerf,

But this is not working, after taking the filter  as a list box it shows only 0 .

[vinieme12]

use

Wildmatch(Team,'*iperformance*') as iPerf,

[smilingjohn]

Hi Vineet ,

but how do i create the flag for the same , with 1 and  0 ,

That is there should be a flage if the teams has Iperformance then it should slecte as 1 else 0

[vishsaggi]

Extending Vineeth's Script you can try like:

IF(Wildmatch(Team,'*iperformance*') > 0, 1, 0) as iPerfFlag,

[sasiparupudi1 · Accepted solution]

Like this may be?

Table:

Load

    Id,

    Team,

    if(SubStringCount(lower(Team),'iperformance')>0,1,0) as IsValueAvailable;

LOAD * INLINE [

Id,Team

1,324e iperformance Test Drive

82,328e Iperformance

99,330e Iperformance

100,330e Sedan Iperformance

180,530e Iperformance

181,530e Xdrive Iperformance

182,530e Xdrive iperformance

183,530e Xdrive

];

[MarcoWedel]

that's what the proposed expression should deliver ...