consolidating values into one value

[#1]

Hi,

I have created a Performance chart for my team.

data stewards log their performance with project name, number of lines reviewed.

but the problem is that they all have named the project name slightly different.

ex: Data Cleanup , Data Clean Up, Project - Data Clean up, Cleaning up Date, Project Name : Data Clean up... etc...

So in the future I will provide dropdown so that they can choose the name of the project.

but the past data are all pretty messy as you can see from the example that I provided above.

all those values are under the column named "Project Name"

is there any way that i can write up something so that QV can consolidate those names into one single name for example "Data Cleanup"

there are other projects too so in order to compare them properly I need these to fall under same bucket.

Thank you!!

[#2]

you can rename your fields wicth "as"

load

Cleanup Data as [Cleanup Data],

....

from ...table a;

load

Data Cleanup as [Cleanup Data],

....

from ...table b;

[Clever_Anjos]

You can use a Mapping table to rename your projects

Map:

Mapping LOAD * inline [

     Old, New

Data Cleanup ,  Project - Data Clean up

Data Clean Up, Project - Data Clean up

Project - Data Clean up, Project - Data Clean up

Cleaning up Date, Project - Data Clean up

Project Name : Data Clean up, Project - Data Clean up

];

Map ProjectName using Map;

[alexpanjhc · Accepted solution]

load *,

if(wildmatch(projectname, '*Clean*' )>0, 'Project - Data Clean Up','') as projectname

from table

[#5]

Thank you alex! this worked perfectly