topic Re: field value remove in QlikView

field value remove

sanjujeeboy — Wed, 25 Nov 2020 16:16:04 GMT

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 — Wed, 04 Apr 2018 12:38:20 GMT

Use the function "Index"

Example:

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

olivierrobin — Wed, 04 Apr 2018 12:38:32 GMT

hello

tou can use the match/wildmatch function

or maybe a condition like

left(description,6)='

sanjujeeboy — Wed, 04 Apr 2018 12:40:40 GMT

how to use wildmatch in this case

olivierrobin — Wed, 04 Apr 2018 12:46:45 GMT

maybe

wildmatch(description,'Sample*')

if it matches, it returns 1

thevingo — Wed, 04 Apr 2018 12:50:18 GMT

Add this at the end of load table like

Your_Table:

Load ....

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

sanjujeeboy — Wed, 04 Apr 2018 12:54:57 GMT

thanks. it worked