Forum Discussion
Question for appending Names
Hi DeBIe ,
Why don't you do a dimension table with the connection between the current name and names you have something similar to this:
| Name | Current Name |
| Peter | (Administrator) Peter |
| (Administrator) Peter | (Administrator) Peter |
| Andrea | Andrea |
| (Local Admin Andrea) | Andrea |
then relate by name column with your other table and make the calculations with current name.
Only question here is that this table needs some maintenance.
Hi MFelix ,
that is one of the options I thought of, but I was wondering if it would really be needed to create a separate dimensional table to realize this. I feel like if this similar to this are going to happen, my datamodel will grow and grow and it will eventually not be maintainable anymore.
Hi DeBIe ,
Only question I have with this type of data is that you can have more than one rule to acommodate all the roles or small changes in the names, you would need a to have filters or measure or slicers and then it's the same ammount of work if not bigger than to have the relational table.
Just giving options
Hi MFelix I do not understand what you are trying to say?
Problem with creating a dimensional table for the names is a option. But how would I create the dimensional table based on latest usernames?
The way I create dimensional tables now is first to duplicate. Then I remove the columns which I do not need and then I remove the duplicate (names). The original column where I created the duplicate from, has over 500.000 records and it will get more. That means that the dimensional table has to load this amount of data as well because it's a duplicate. Is there a better way to do this?
