Exclude rows from a Name Column based on certain t... - Qlik Community

Azeem2018 · ‎2022-11-25

hi,

New to qlik sense (previously working with Power BI and excel),

i have a name column which contains rows which are dummy (like TEST1,TEst2,etc...)

1) i want a formula in 'Data load editor' or at back end to exclude such rows in final table which will be displayed in Analyze Sheet.

2) further when we have to apply a expression in front load or back end load. guide me some reading reference or some online course to understand.

in data load editor:

'RELATION_NAME,'

Relation _Name:

Mr. A

Mr. B

Test 1

Test 2

Mr. C

Mr. D

Mr. E

.

Mr. ABC .

brunobertels · ‎2022-11-25

Hi

see this example below with the wildmatch function :

here wildmatch is using in a where clause

inside the script it could seem somethink like

if(wildmatch(Field,'X,''Y','Z'), Field, null()) as Field ,

Or if(wildmatch(Relation _Name,'*Mr*','*MR*),null(),Relation _Name) as Relation _Name,

hope it helps

Exclude rows from a Name Column based on certain text