If function

[#1]

So I have many values that I need to assign to a column depending on another column.

if 'Group Description' has 'WR' in it, I need to display 'blank'

if 'Group Description' has 'Support' in it, i need to display 'blank'

etc

etc

etc

So if this one big if statement? And all I wanted to do is search the field group description for specific things, like 'WR' or 'Support' and many others.

Then display something else in my 'Catagory' column.

Can I use wildmatch?

And I would like to do this in the script.

Thanks!

[swuehl · Accepted solution]

The wildmatch() functions are just used as conditions in the if() statements. So you essentiall need to think about what your conditions are and what you want THEN to do and what ELSE (in the then / else branches, second and third argument to if() statements).

I am not 100% sure what your requirements are, but you could try something like

LOAD *,

if

(wildmatch([GroupDescription],'*Non WR*'), 'Improve/Enhance',

if(wildmatch([GroupDescription],'*Project*'),if(wildmatch([GroupDescription],'*Suite 4*'),'Lean','Projects'),[GroupDescription])) as Metrics_Catagory

INLINE [

GroupDescription

Non WR Test1

Non wr Test2

Non WR sdfdsfsd

Project Suite 4 1

Project Suite 42

Suite 51 Project

Suite 42 Project 2

];

[#3]

That worked perfectly. Thanks for all the help.

I continue the same pattern if I want to format others as well?