Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to extract continuous string set from a column with multiple criteria

Hi, I have a Column A with client names. Table 1                                                                      Table 2 Client Name                                                         ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Anonymous - OK, I updated this with a Client Name output version and Project output version in 2 additional columns. I checked the matches, don't see anything obviously amiss. Solved?

     

    PBIX is attached. 

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

Anonymous - Correct me if I am wrong, but this would fail in the case of the sample data you provided, specifically:

 

LLP Ernst and Young trying to match with Ernst and Young

 

If I go with the first three trying to match, it will never return Ernst and Young because LLP does not equal "Ern".

 

Right?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Greg_DecklerNo. The first 3 and above characters are to be taken from the reference table(column) and then search for a match in the client name column. 

So 'Ern' will be matched with the client column to return the result for wherever the string 'ern' appears. So this way LLP 'Ern'st and Young will be mapped to 'Ern'.

 

I got the solution for this logic from a friend of mine using the PHP code. I am not sure of how to have this integrated to my Power BI. I have provided the link to my drive having the result file (.csv) and the code image for your reference. If you could help me with a way to implement this with Power BI that will fix the problem.

 

-------------------->    Drive Link 

 

Thank you for your time. Really appreciate it.