Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
load *,
if(wildmatch(projectname, '*Clean*' )>0, 'Project - Data Clean Up','') as projectname
from table
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;
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;
load *,
if(wildmatch(projectname, '*Clean*' )>0, 'Project - Data Clean Up','') as projectname
from table
Thank you alex! this worked perfectly