Forum Discussion
How do you exclude name columns due to inconsistent naming conventions
The database has consistent job numbers but the job names are not consistent. Each month as data was loaded, the job numbers remained the same (correct) but whoever loaded them put slighltly diffe...
There are likely a number of ways you can solve this, but the way I would do it is,
Duplicate the dataset, on the new dataset [Table2] Keep only "Job" and "Name", & remove duplicates on Job number column. Now you're left with a table of unique value job numbers, each with a corresponding name.
Now just create a one to many relationships using the "Job" columns, and use the "Name" from [Table2] in your matrix.