Forum Discussion
Matching values then performing lookup
I have a dashboard that contains employee information (name, e-mail, etc.) that is pulled from our HR system. I have been asked to add the users' sAMAccountName from Active Directory to the dashboard...
After importing your two separate tables, create a relationship joining emailaddress from the CSV file with your HR data.
Then in your table visual or other visual, the sAMAAccontName will be available to display.
If you wanted, you can use the LOOKUPVALUE function to populate your HR data with the sAMA value.
Hope this gets you going in the right direction.
Thank you; I will give that at try and provide an update!