It "appears" that there may be a problem with Expand Columns after using Merge Queries in dataflows. I have a scenario where I have a Merge that results in the following table; when I select a specific table value in the srcData column, I can see the subsequent values all match the criteria (matching CID, GoLive, and EndDate):
However, when I expand the srcData column and select just the ID column from the linked table, I get an ID of 1 instead of 5 for all of the 125 -> 7/1/2001 -> 5/1/2018 items:
This even happens if I filter to just a single record and then expand; I can't find a rhyme or reason for this behavior but really hope there's either a reason or the bug gets resolved soon.
1 Comment
v-chuncz-msftCommunity Support
You may take a look at the post below.