Compare daily datasets and include records where any column changed
We are trying to create a simple 'changes' file for one of our app projects. The idea I had was to create a QVW load that has a variable for 'EvenDay' and 'OddDay', the variable is tied to an if statement to reload the same SQL script consisting of all of our employees included in the project. This way if daynumber(today()) is odd it will store the results in the Odd QVD and visa versa for when day number is even.
Both datasets will have the exact same columns and will have an EEID key field. I want to be able to compare the two datasets linking by the EEID to see if any data in any of the columns have changed between today and yesterday. If something has changed (email, job, resigned, etc) then I want to keep only the records from today's dataset where the list of columns does not match yesterday.
I was thinking of just loading in both QVDs and concatenate them and say if yesterday.name <> today.name then today.name. I just figure there is probably a function to use in Qlik to compare when you have a key field to rely on.
Yes, sorry about that. I am not trying to make anything in the front end, just a QVW to handle the comparison and I'm going to push the 'exported' set via REST. I assumed I would do the comparison on load. The input tables will not need to be kept, but I may have an appended QVD for anything in the 'exported' table so I can keep track of what has changed.