Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hI Community,
my data are organized as below
Colum1
SE/1
SE/2
SE/3
SE/4
ORD/5
SE/6
ORD/7
I need to exclude ORD records not in loader script but in the user interface
I create a table
I add a column called Order
I need to exclude all the records starting with ORD/
How I could do it?
Thanks
Fabio M
This won't be possible in a table box, but in a straight table you can add an expression like this:
If(not WildMatch(Column, 'ORD*'), Column)
or you can also use set analysis if Column is your dimension
{<Column -= {'ORD*'}>}
Create a flag in script
if(wildmatch(lower(Column),'ord*'),0,1) as Flag
Now in Expression use this flag
=Sum({<Flag ={'1'}>}Value)
A front end calculation or calculated dimension is the simplest solution (as per SunnyT), but may not perform well in a large data set. In this case, setting a flag and use a set expression to exclude the ORD values will perform better (as per Kush)
Hi Fabio,
If there is a lot of data which could possibly be excluded with the front end expression its always better to do it in your load script as this will improve your performance. Other wise Sunny's reply should help solve your issue for sure.
Thanks,
Sangram.