Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have column where data is like this
abc123
abc345
abc789
def234
def908
def9239
now i am trying to create filters like if
if(Substringcount(Column1,'abc'),'Value1_abc','Value2_def')
user select value1_abc from table then this show select all abc data which is starting from abc and if user select value2_def then this should be select all def data how i do this
Hi,
may be it better add a new field in you data set like:
Load *, Left(data,3) as Category Inline [data abc123 abc345 abc789 def234 def908 def9239
];
May be it will help you
Test:
LOAD *,
if(WildMatch(FIELD_1,'abc*')>0,FIELD_1,Null()) as FIELD_2,
if(WildMatch(FIELD_1,'def*')>0,FIELD_1,Null()) as FIELD_3;
LOAD * INLINE [
FIELD_1
abc123
abc345
abc789
def23
def908
def239
];