Forum Discussion
Add custom grouping
I have a need to group department information by commonly referred names non-existent in the data. To use a grocery analogy, if I had commonly referred names of: Produce Bakery Meat Department...
Anonymous
In this scenario, it's better to add a category id column in both tables, and build the relationship based on this id column. You can hardly populate the commonly referred names based on Department Name matching only.
Regards,