Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In A dimension field I am having values from 1 to 100 and I want to exclude values from 5 to 10 at script level.
Maybe: sign(match(Field,5,6,7,8,9,10)) as Flag and using it as where/selection filter or set analysis condition.
Thanks for replying
But in dimensions the values are like example 5.1,5.2,5.3....9.8,9.9 I need to exclude all the values at script level itself
Load *
From SomeTable
Where SomeField >= 5 and SomeField <10; // This assumes the values are numeric or can be converted to numbers
This might be solved with the following adjusting:
sign(match(floor(Field),5,6,7,8,9,10)) as Flag
or you change it to something like:
-(Field >=5 and Field < 11) as Flag