Power Query Merge and Expand Table Issue RRS feed

  • Question

  • I have two queries both referencing a same query as the source. Query 1 contains document headers and Query 2 document line items. I merged the two queries using the DocumentID column that exists in both queries. When I expanded Query 2, I found some records in Query 2 have incorrect DocumentID values. I checked that the table has correct values before expanding the table. Can anyone help please? Thanks.

    Tuesday, May 15, 2018 2:18 PM