Forum Discussion
Comparing multiple Organizations with Base Organization
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 table
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 orgI 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