Hello Everybody,
I am facing an issue about how to match IDs, but also listing the IDs from the two sources which don't match. Please see the below example:
Below I want to match the IDs and to see if there are any values which have a variance and I need to investigate.
Input:
Data Set 1
ID Value 1 Value 2
1 100 100
2 200 200
3 250 250
4 300 300
Data Set 2
ID Value 1 Value 2
1 100 100
2 200 200
3 250 250
Output:
ID Data Set 1 Value 1 Data Set 1 Value 2 Data Set 2 Value 1 Data Set 2 Value 2 Difference Value 1 Difference Value 2
1 100 100 100 100 0 0
2 200 200 200 200 0 0
3 250 250 250 250 0 0
4 300 300 0 0 300 300
This is the WF I came up with:
But I am also having issues, because it looks like the WF is double counting some of the values, see below my summarize tool:
Please help.
