flag

[smilingjohn]

HI All ,

Please find the attachment of the sample excel and qvw file ,

I want to have a field in the script level which will have only those teams names which has "iperformance"

and also a flag which is 1 if team is iperformance .

Thanks

[Anonymous]

May be you can try below script

LOAD Team,

     ID,

     loc,

     if(WildMatch(Team,'*iPerformance*'),1,0) as flag_isIperf

FROM

(ooxml, embedded labels, table is Iper);

[smilingjohn]

Thakns Shiva

this will give me a filter , but i want to have a seprate field from the team field which will have only ieprformace in it .

Regards

[Anonymous]

Didn't get you exactly. Do you want a field like column2 with value **** iperformance as value for those records which has the word in the team name  and empty for other records. If yes, Please try something like below,

LOAD Team,

     ID,

     loc,

     if(WildMatch(Team,'*iPerformance*'),1,0) as flag_isIperf,

     if(WildMatch(Team,'*iPerformance*'),Team,'') as NewTeam_Field

FROM

(ooxml, embedded labels, table is Iper);

[gerry_hdm]

Hello John

Grüsse Gerold

[gerry_hdm]

Here is a example

Gerold 

[smilingjohn]

Thanks shiva this is what i wanted ,

and one more thing shiva , when i creat the filter for iPerformance , i have to show it like thi in the frnt end , as shwon in the screenshot.

Wheni click in the check box it should show me all the value re;ated to iperformance ,

I tried to that but when i take filet i have 0 and 1 , 'where  as the requirement is to show a check box filter , if we click on the check box it is like selecting 1 .

[Anonymous · Accepted solution]

May be like this