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.
Hi @Derrick060622 I mocked up approach to tackle this which I think will be dynamic to deal with addtional columns being added in your process.
I tried this, but it only lists out the entire data sets from both of the examples, it doesn't match the IDs and it doesn't place the values with the same ID on the same line with the difference. Is there any match the IDs to each other with the difference? Or would the IDs have to be listed in order or could they be random?