I am extracting data from two different vendors, the data I'm extracting should be the same, however a quick glance indicates it isn't! For example, lets say one file contains a list of 1000 students' names. The other file contains 987 students' names. What's the best way to cross reference both documents to discover who is missing?
A similar request: What if a file contains every bit of information I need to upload into PowerBI, however, it's missing one data point I need to connect a relationship. I can add the column, but not sure the best way to ensure the data aligns to the correct student name.
For example, I'm building relationships off unique State Student Testing Numbers, but the great, clean data file I'm about to upload doesn't have each student's testing number.
I'm new here, thanks for all the help!
A similar request: What if a file contains every bit of information I need to upload into PowerBI, however, it's missing one data point I need to connect a relationship. I can add the column, but not sure the best way to ensure the data aligns to the correct student name.
For example, I'm building relationships off unique State Student Testing Numbers, but the great, clean data file I'm about to upload doesn't have each student's testing number.
I'm new here, thanks for all the help!
