Forum Discussion

JontySchulz's avatar
JontySchulz
Frequent Visitor
7 years ago
Solved

Expanded data incorrect when merging two queries

Hi All,   I've got a problem where I've merged queries, and yet somehow when I expand the data the data that is output comes from a different query... not the one I originally merged to!    The s...
Need Help
  • JontySchulz's avatar
    JontySchulz
    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

alfranco17's avatar
alfranco17
Advocate I
7 years ago

Had the same problem. It was driving me nuts. 

 

In the end, I took your advice, added a "Remove errors" to the lookup query, and the error went away.

ncbshiva's avatar
ncbshiva
Advocate V
6 years ago

Even for me also , i had tried everything by applying Trim and Clean text , but did not work.

After adding Remove Errors , the merged query returned correct results.

 

This is crazy , not sure about the issue.

  • SkyKing's avatar
    SkyKing
    New Member
    1 year ago

    Here I am 4-1/2 years and a pandemic later, same problem.