Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need some help comparing tables and outputting the differenses to track changes. I store away all orders with ordernumbers, orderrows and productid every day 5 days back and delete anything older. I need to load all these files and compare them to one another and present the changed orderrows in a chart.
If the loaded table has this in it:
Savedate Orderdate Ordernbr Row ProductID Qty
110501 110301 12345 10 5555 4
110503 110301 12345 10 4444 4
Then that change should be visible in the chart
Although theese two rows:
Savedate Orderdate Ordernbr Row ProductID Qty
110511 110401 15555 10 3333 3
110513 110401 15555 10 3333 3
Would'nt generate any output in the cart
So basically: I want to compare a row with every other row with different SaveDates and see if there is any changes in Qty or/and ProudctID. If there is, show it in a chart.
How would the expression for doing this look like? I'm feeling very stuck with this
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,
Bikash
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.
Thanks!
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')
Orders_temp:
ADD LOAD
ArticleNumber,
Qty,
date(SaveDate,'YYMMDD') as SaveDate, // when this file was saved
Ordernumber,
Rownumber
FROM $(File) (qvd);
next File
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
Do you found a solution?
I have the same problem 😕