Forum Discussion
Solved
Amount duplicated after appending query
Dears, I'm facing an issue that I appended 7 tables but when I check the data I found that amount duplicated without any reason although source file amounts aren't duplicated Thanks
Hii hanyfouda2023 ,
You might have appened the same table several times. I'd usually add a custom column named Source which value is anything that describes the sourc to each table that I append so I'd know where my numbers are coming from. This practice makes it easy to troubleshoot for errors.
Dear Danexitan,
Thanks I added the columns , and found which amount arent right. Do you have any idea how to solve it
Ì am not sure. Questions are:
Why are the amounts not right?
Did you append the several times?
What makes them being duplicated?
Why are the amounts not right? Yes its duplicated
Did you append the several times? Yes
What makes them being duplicated? I need to know why figuers not accurate