Forum Discussion
Values Change in Append
My apologies for the delay in response here. I was on vacation when you asked the question and the email was lost in my inbox until now. I did solve this purely by luck. It appears that if you have conflicting privacy levels (and sometimes even not) the append will give different results. I turned off the following option in my reports and things stablized:
File=> Options and Settings => Options=> Privacy
From there I chose the other radio button option "Ignore the Privacy Levels and potentially improve performance".
Hi zimmermanaric,
Sorry for the question but Why are you making new appends with several SQL and not a single SQL for everydata?
could it be possible that you are repeating data everytime you add a new query?
Regards,
MFelix
I really appreciate your thoughts! It is 4 sql statements that are written the same way, pulling the same columns and years, but connected to 4 differnent databases.
Did you figure out why this is happening? I'm having the same issue.
I have two queries being appended into one. Each time I refresh the values from the appended table change, even though the values in the original two queries stays the same.
No I have not. I think I am going to have to open a ticket with Microsoft to help with this issue.
I actually just fixed mine. In my original queries, I added an order by clause at the end. I don't know why this fixed it, but it did!
ORDER BY [TABLE_NAME].[COLUMN_NAME] ASC
Maybe this will fix yours as well? Good luck!
