Forum Discussion
Merging queries - incorrect value after expand table
Same issue here. That make no sense, but what I noticed is that matching by dates may have something with this. I'll transform dates to text and then merge and expand.
I got it!. Not sure what causing it and I had no luck with it changing dates to text or combining key columns into one and then merge by new column. Finaly as the issue was caused by expanding nested table, I've tried Table.Join function instead of Table.NestedJoin which is used when we merge using Merge tool from the ribbon. Difference is that Table.Join creates table with expanded all columns from both merged tables. It does not create a new column with nested table. Downside is that you need to handle column name duplicates between two tables but that's clearly explained in the function documentation which can be found here.