Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

consolidating values into one value

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!!

1 Solution

Accepted Solutions
alexpanjhc
Specialist
Specialist

load *,

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

from table

View solution in original post

4 Replies
Not applicable
Author

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
Employee
Employee

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
Specialist
Specialist

load *,

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

from table

Not applicable
Author

Thank you alex! this worked perfectly