Snapshot Challenge with #list
My scenario today,
Integration runs everyday and clear the below numbered list with data. Since the build has been done without the code i'm struggling to create the code with unique combination.
My objective is : I want to copy the current data before the delete process will execute. and compare it against the data that will be newly loaded. IS there any best way you can suggest me? My ideology will be :
1. Create a "Snapshot Code" property in the Master CC list as it will act like a code for comparison.
2. Create a new list called " Masters CC Snapshot" and same properties
3. Import the data with code from Master CC list to Masters CC Snapshot. (Here I'm unable to form a unique code)
4. Write a logic : Mistmatch ? = Master CC.CC <> Master CC Snapshot.CC[lookup:Snapshot code]
5. Delete the snapshot list data if there will be no mimatch boolean checked.
Any ways you can suggest me which you have faced based on your experience?
Answers
-
@GirishK my issue is that I'm unable to create a unique combination of code. How do i take it further for copying/snapshotting the data in the other list?
0 -
It is hard to tell, but based on what you have above, the code should be CC_CE_KPU and then import the transactional data (Amount) into a module dimensionalized by that list and Time. Remember, you shouldn't be importing data into properties, especially transactional data like you have above. For more information about this, read this.
1 -
@aishabhy05 you can create a unique code by combining the key KPIs - (Text) CC & "_" & CE & "_" & KPU
Then, import the unique code into Masters CC Snapshot as "Code"
0