Forum Discussion
Solved
Comparing multiple Organizations with Base Organization
Hi Everyone, i have a dataset with org codes and routes (please find a sample below), i want to fix 'A' as my base client and i want to compare the base routes to the routes of all other clients; ...
pls see if this is what you want. you can select differnt org code to see different result
what's the expected output based on the sample data we have?
If we take A as base client,
this should be our desired result:
| Bangladesh-Chattogram-Durban-Durban-Port Elizabeth-Standard | B | Extra |
| Brazil-Itajai-Durban-Durban-Cape Town-Standard | B | Extra |
| Belgium-Antwerpen-Direct-Durban-Durban-Standard | C | Missing |
| Belgium-Antwerpen-Port Elizabeth-Port Elizabeth-Durban-Express | C | Missing |
| Belgium-Antwerpen-Richards Bay-Richards Bay-Durban-Express | C | Extra |
Missing means the data in A not in but in other org,
Extra means data not in A but still in other org
I think we can do that for extra, but I don't know how to do that for missing.
It's becuase it will automatically create new data.
e.g we have org code, a-z, we only have one route for a, then the output will be 25 rows for b-z and mark as missing.
Let's see if anyone else have better solution for this