Forum Discussion
lordbyronxxiv
Apr 08, 2022Copper Contributor
Need to fill user id and name from range of cells
I have an excel sheet with over 580K rows of data, it is of user logins, and it gives the username, but not necessarily the full name and it does not give the employee id. See below picture wh...
lordbyronxxiv
Apr 08, 2022Copper Contributor
Thank you for that, unfortunately I forgot that there is actually no common unique field in both tables, the customers table does not have a field for userID, so I may end up having to do it manually, the customers table only has userID and Full Name, and the logging table has the UserName. Thanks anyway
Riny_van_Eekelen
Apr 09, 2022Platinum Contributor
lordbyronxxiv Since you mentioned to work with 580 thousand rows of data, and assuming that you try to match more than just a few customers, perhaps fuzzy matching in Power Query can be used to match (most of) the ID's with the full names. See attached file.