From the course: Excel: Power Query (Get & Transform) (2020)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Merging inconsistent data with a transformation table

Merging inconsistent data with a transformation table

From the course: Excel: Power Query (Get & Transform) (2020)

Start my 1-month free trial

Merging inconsistent data with a transformation table

“

- [Narrator] Here we have two data sets that need to be merged. Over on the left we've got the volunteer information and how many hours they volunteered and where. We would like to get that matched up by this center code, manager, and address. Look at Cole, who did six hours at city center. We need to get H seven zero nine, and Kristine, and 24 Davis Street over next to Cole. But look, we got a problem, Evan has downtown. We don't formally have a downtown office, that's also called city center. It's formally called city center. And then Jake in row nine has NW instead of what's formally known as North West. But we've got to do a left outer join, but in the old days we would have had to clean this stuff up get it all consistent so that it would match, but today we have a transformation table. I'm going to un-hide it. In order to have a transformation table work we have to have a from column and a to column. So this is…

Contents