I hope I am lucky to find this post. I was wondering if you found
any solution to this problem. I shall be ever grateful if you could please
explain to solve such issue.
Thanks & Regards,
This looks like a fairly similar requirement to a couple examples I've made. One shows comparing data across three different months. It shows ALL the data, and highlights differences. The other shows comparing data across two different tables. It removes rows that are the same in both tables, and highlights differences.
Although I still can't get it to work. I have a few more dimensions. The load script looks like this
for each File in filelist ('c:\History\*.qvd')
date(SaveDate,'YYMMDD') as SaveDate, // when this file was saved
FROM $(File) (qvd);
We can assume that Ordernumber and Rownumber is static. I then want to compare which Articlenumbers and/or Qty:s are changed in each Ordernumer/Rownumber for each SaveDate