Hello everyone,
I am having 2 tables. one is for daily reload and second one is incremental qvd for daily qvd.
Here we are having 5 fields, we are capturing daily data,if there is any change in 5 fields then those records are storing into incremental qvd .
This process we are doing by AutoNumber condition.
Now, If we want to add any new field to this list, instead of adding that field in If condition manually
is there any way to check if any change is happened in the records.
Daily Qvd have these records:
| Item Name |
Dim1 |
Dim2 |
Dim3 |
Volity Code |
Last Updated |
| 123 |
10 |
15 |
7 |
C |
12/26/2024 |
| 124 |
5 |
6 |
10 |
B |
12/24/2024 |
Incremental Qvd is having below records:
| Item Name |
Dim1 |
Dim2 |
Dim3 |
Volity Code |
Last Updated |
| 123 |
10 |
15 |
7 |
A |
12/24/2024 |
| 124 |
5 |
6 |
10 |
B |
12/24/2024 |
My result would be like
| Item Name |
Dim1 |
Dim2 |
Dim3 |
Volity Code |
Last Updated |
| 123 |
10 |
15 |
7 |
A |
12/24/2024 |
| 124 |
5 |
6 |
10 |
B |
12/24/2024 |
| 123 |
10 |
15 |
7 |
C |
12/26/2024 |
We are using AutoNumber(Dim1&Dim2&Dim3&Volity Code) as KEY
we have added new field for comparison and field name is Weight
| Item Name |
Dim1 |
Dim2 |
Dim3 |
Volity Code |
weight |
Last Updated |
| 123 |
10 |
15 |
7 |
A |
30 |
12/26/2024 |
| 124 |
5 |
6 |
10 |
B |
20 |
12/24/2024 |
AutoNumber(Dim1&Dim2&Dim3&Volity Code&weight) as KEY
Instead of checking field values manually by using AutoNumber whether it is changed or not is there anyway to automate or direct function to compare between rows and identify which is having duplicate records and which is having distinct records.
Thank you in Advance
