multiple wildmatches!

Wed, 25 Nov 2020 16:16:04 GMT

Hi guys! I have a question with wildcard match and I prepared a example data.

let's say there is basically 4 projects

Drilling / Painting / Sanding / Leveling. but as you can see from below example Drilling and Painting are logged all differently whereas Sanding and Leveling are logged fine.

1. I want to have all the rows that have "drill" in them show up as "Drilling" and all the rows that have "paint" and "Painting"

2. Sanding and Leveling should come up as it is.

what I am doing at the moment is using a wildcard search.

if(wildmatch([Project Name], '*drill*' )>0, 'Drilling','') as [Project Name],

this worked but only partially. anything that does not have "drill" in them.. so all the other projects where dropped...

and I could not use two wild matches at the same time. for example,

if(wildmatch([Project Name], '*drill*' )>0, 'Drilling','') as [Project Name],

if(wildmatch([Project Name], '*paint*' )>0, 'Painting','') as [Project Name],

QV won't let me do this.

is there anyway i can do multiple wildmatches and at the same time bring all the rest that does not match the match rule for wildmatch?

Thank you in advance!!!

Project Name

drilling project

Drilling Project

Drill Project

Drill project A

drill Project B

Painting job

Paint job

Paing blue job

Paint red

Sanding

Leveling

Re: multiple wildmatches!

sunny_talwar — Wed, 19 Oct 2016 20:12:49 GMT

Are you trying to do this:

If(WildMatch([Project Name], '*drill*'), 'Drilling',

If(WildMatch([Project Name], '*paint*'), 'Painting','') as [Project Name],

Re: multiple wildmatches!

maxgro — Wed, 19 Oct 2016 20:22:44 GMT

Source:

load

Pick(WildMatch([Project Name], '*drill*', '*pain*', '*'), 'Drilling', 'Painting', [Project Name])

as [New Project Name]

inline [

Project Name

drilling project

Drilling Project

Drill Project

Drill project A

drill Project B

Painting job

Paint job

Paing blue job

Paint red

Sanding

Leveling

];

topic Re: multiple wildmatches! in QlikView

multiple wildmatches!

Re: multiple wildmatches!

Re: multiple wildmatches!