check for certain value in field

[markgraham123]

Hi all,

I'm trying to create a flag if ID has 0102 or 0607 in its name. Can someone please help?

ID, Name

1,   0102,0304,0102, 0909

2,  0102,0607

[julian_rodriguez · Accepted solution]

Hello Mark

On the load script

LOAD

     If(Index(Name,'0102')>0 Or Index(Name,'0607')>0, 1,0) As FlagId,

.....;

Then you can select all the rows that has 1 as FlagId

Regards

[sunny_talwar]

May be like this:

LOAD ID,

          Name,

          If(SubStringCount(ID, '0102') >= 1 or SubStringCount(ID, '0607') >= 1, 1, 0) as Flag

FROM...

[Anonymous]

in a Chart create e.g calculated Dimension like

=if (match(Name,'0102','ß607') > 0, Name, null()) and suppress Zero values

in script you may load

load ID,

Name

from ...

where match(Name,'0102','0607') > 0;

[maxgro]

maybe

WildMatch(Name, '*0102*', '*0607*')

[markgraham123]

Sunny,

What if i have my date set :

ID, Name

1,   0102,0304,0102, 0909

1,   0102,5594

2,  0102,0607

2,  0102,0609

[sunny_talwar]

It should still work, I think

[markgraham123]

Thanks

[markgraham123]

Sunny,

What if i have 100 s of names and i want create a loop to dynamically check and assign flag in back end for every name existence??

[markgraham123]

i have names from 0101 to 0990 (May be group by name or something)

If any ID has name 0101 then i want to give flag 'Y' for 0101

.

.

.

.

same till 0990