Forum Discussion

nazdravanul's avatar
nazdravanul
Frequent Visitor
8 years ago

Merge problems - incorrect expand

Hi all,    I have the following problem. I have 2 tables, which have the following approximate format:   Table 1 (selection of columns)   Email           Transaction ID  Date              Payme...
Need Help
richard-powerbi's avatar
richard-powerbi
Post Patron
6 years ago

You need to add Table.Buffer to the last step in the Query you are going to merge later into another Query (the query where the expend goes wrong). Same as how you need to Table.Buffer if you want to remove duplicates and always keep the 1st item after a sort.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

TL;DR - Table.Buffer() fixed issue

Also had this issue.  Completely incorrect join results after merge (Left outer), with seemingly no sense as to how it was processing join and delivering expanded columns (this was joining on multiple columns)

Attempted numerous fixes:  data types, clean & trim, recreating entire structures from scratch - spent 24hrs on this blinkin issue

As above - added Table.Buffer() to the table which formed the right side of the join (this table was gettings its data from a source table which contained a Group By and index).   It worked!   

Thanks all for tip