Problem with merging cells into master in Power Query

[ben_sorensen]

So I have a file that I have been working with. I append to files together, no problem, 85,000 rows.

Then I go back into the query and merge a file in, essentially a vLookup on country codes into country names, no problem, still 85,000 rows.

Then I go and do another merge, another vLookup, essentially taking all the labels in one category and reassigning them a more generic label in another column for easier less-granular analysis, and suddenly I have 87,000 rows of data.

I am trying to understand where the disconnect was that created those copies of rows of data. I know that I can do a remove duplicates but want to understand where I am doing something wrong.

Thanks for your help.

Best
Ben

 

[VBA Geek]

You may need to check the JoinKind passed to the Table.NestedJoin function

you have several possbilities:


JoinKind.FullOuter


JoinKind.Inner

JoinKind.LeftAnti

JoinKind.LeftOuter

JoinKind.RightAnti

JoinKind.RightOuter

Table.NestedJoin function



It looks like you are performing a left outer or right other join whereas you have to use a right outer (if currently using a left outer) or a left outer (if currently using a right outer) or perhaps you need an inner join

 

[ben_sorensen]

You may need to check the JoinKind passed to the Table.NestedJoin function

you have several possbilities:


JoinKind.FullOuter


JoinKind.Inner

JoinKind.LeftAnti

JoinKind.LeftOuter

JoinKind.RightAnti

JoinKind.RightOuter

Table.NestedJoin function



It looks like you are performing a left outer or right other join whereas you have to use a right outer (if currently using a left outer) or a left outer (if currently using a right outer) or perhaps you need an inner join

Tried that and now every time I select something other than LeftOuter I get a "Data.Format.Error=We couldn't convert to a number. Details: NA"

These aren't numbers that I am trying to vLookup into the data. I just don't understand why it keeps adding rows.

Any other ideas would be appreciated.

 

[VBA Geek]

They keys on which you perform the joins do not have to be numbers, but between the two table they do need to have the same data type. But it is difficult to know about your case without seeing the data

 

[nikio8]

If you are getting more data most likely you are joining tables with duplicated values.
if you click on the empty space in the new Table column, possibly you can see more than one row merged at the bottom. you created many to many connection.
perhaps delete some of your data and see how it goes in smaller range.