Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I need to exclude one value form the field which is coming dirctly from tha table. How to do
May be this?
If(Not WildMatch(FieldName , 'FieldValue'), FieldName)
Or
Aggr(Only({1<FieldName -= {'FieldValue'}>}FieldName), FieldName) // try without 1 operator
If you don't need that anywhere in the dashboard, you should exclude it while loading using WHERE clause like:
Load
status,
....
From <> Where status<>'DELETED' ;
i need to do that in script itself
i need to exclude 'DELETED'
You can use like below
LOAD * Inline [
Field
CREATED
DELETED
UPDATED
] Where Not WildMatch(Field, 'DELETED');