Forum Discussion
Amount duplicated after appending query
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.
Hi hanyfouda2023 ,
It is a custom column in the query editor. In Add Column tab, go to custom column and create a Source column that indicates the source of your data. Do this for all the seven tables. Make sure to use the same column name for all of them.
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