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
you are welcome
Hi ryan_mayu ,
I was wondering if there would be a way by which i dont have to select the CompB,
need to show the comparison of all the other organization against base client
and need to show that list in a tablewhat'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