Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be like this
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);
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
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);
Hello John
Grüsse Gerold
Here is a example
Gerold
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 .
May be like this