Merge Queries is showing correct number, but Expanding columns is showing incorrect numbers

[dgilm33]

I can't share the data due to confidentiality, but essentially I am trying to merge on two tables and expand columns in the next step. In both tables I clean the data before merging. After merging the numbers are correct. However, when I expand columns the numbers are changing and are incorrect. I've tried removing duplicates but the number remains the same, so I do not think that is the issue. I've read where some people suggest using table.buffer, or using fuzzy matching in the merge and setting max number of matches to 1, however these cause the merge and expand to run for long periods of time. Why would the numbers be correct after the merge, but incorrect after the expand, and is there a way to fix this?

[Anonymous]

Hi @dgilm33 ,

Based on this ——I can't share the data due to confidentiality. You may provide some dummy data and screenshots to help us clarify your scenario.

In addition, which merge type you used ?

Best Regards,
Eyelyn Qin

[miguel]

Hey!

Could you share any sample files or queries to repro this behavior? If you can also tell us where you're seeing these values (in what particular section of the UI) that would help a lot in understanding this scenario.

Thank you!

[HotChilli]

OK, good, now we have an example to study.

Can you show the lines before the merge (and explain what fields you are merging on - pictures are fine here) and  after the merge (with the focus on the 2592 figure please)?

[HotChilli]

Examples please.  "However, when I expand columns the numbers are changing and are incorrect"

[dgilm33]

One example I've found is after the merge the spend amount is correct, but after the expand step the number is $2,592 higher than it should be