field value remove

[sanjujeeboy]

i have a field called "description" in which there are 100 rows(string)

i want to remove some 10 rows based on word starting with "Sample".

how to achieve this?

[Anonymous]

Use the function "Index"

Example:

IF(Index(FieldName, "Sample") > 0, "Do something here", "Else")

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/StringFunction...

[olivierrobin]

hello

tou can use the match/wildmatch function

or maybe a condition like

left(description,6)='

[sanjujeeboy]

how to use wildmatch in this case

[olivierrobin]

maybe

wildmatch(description,'Sample*')

if it matches, it returns 1

[thevingo · Accepted solution]

Add this at the end of load table like

Your_Table:

Load ....

where not WildMatch(description,'Sample*');

[sanjujeeboy]

thanks. it worked