Forum Discussion
Expanded data incorrect when merging two queries
- 7 years ago
Hi v-lili6-msft,
Thanks for your response.
I was able to get around the error by putting an additional step in the "BaselineStartDate" query. It seemed that somehow the merge was occuring prior to the last "filter" step in this query, hence why the expanded values were different to what I was seeing in the source query. When I put this extra step (which was just a dummy "remove errors" step), it seemed to fix the problem and the numbers in the merged query matched the source query.
Not sure why this was happening and recognise that my solution is only a temporary work-around, but seems to have fixed it for me... for now.
Cheers,
Jonty
I just ran into this as well. Thanks to your post, I added the "remove errors" steps and that fixed it. Not logical, but I'll take it.
Thanks for posting, this was driving me crazy!
Angie