Similar department in each entity
I have a new requirement where I need to flag similar department from all entities. Using the first 3 letters of their code. below is just a sample of the list:
as you can see TMCI and TMSL has the same department (L3) Laboratory and Pharmacy they also have a similar code the 1st three letters starts with LAB this is what I am going to use to identify similar department across all L1 on my list. I just dont know how to start it. above is basically what it should look like in the module. I already have the module in a mapping module where I have the L1 and L3 spread out
any idea how to start it? any suggestions will be appreciated.