Delta record view from a file load
I have a request to load a file to a master list and module, but prior to run this load I want to see what are the delta changes coming in the new file.
So, I thought to park the new file in a temporary list and module and then compare it with master list and module to view the kind of changes I,e New node added, node alias changed, node code updated etc. and then load the file to master list.
but the problem here is, the two modules are using two different dimensions(Temp List & Master List) and in order to view the delta we need to have all master module line item values in temp module but the formula is not working here.
IF Lineitem temp <> Master module.Line item master THEN "DELTA" ELSE BLANK
Is there any other way to handle this scenario?