I am trying to build a simple QV app just to show what changed from previous day's data to today's data.
Data source is oracle and currently planning to take 2 days data initially in two separate QVDs and then a new QVD everyday/reload thereafter. (I appreciate any suggestions here.)
The real data has around 30-35 columns in total.
Data looks like below:
1st day data:
2nd day data:
First Output table:
Display only New Rows that do not exist in Previous Day
Second Output Table:
Show only what changed from yesterday to today and transpose to row level. This is a kind of Delta/ Changelog table.
I have a logic and solution is currently implemented in SQL. But this should be in QlikView on a daily basis.
I appreciate any leads/suggestions.
Thank you in advance.