Multiple Keywords Match Power Query

[Anonymous]

Hi Need,

Help is Identifying Whether My "Error Message" Column has Multiple Keaywords to be matched for "Keywords" Column in Power query. I have Sampled to to 3 lines of error message. I am able to match with one keyword for my other project using Text. Split & List. Intersect but for multiple words i am getting null valuse. Please let me know if anyone have any ideas.

Error Message	Keywords
Member has not met Continuing Work Test to receive Employer Additional contribution	has not met
Contribution header xx,xxx,xxx, is already authorised,contribution for plan member x,xx,xxx must be processed manually.	is already authorised,contribution for plan member
Contribution Transaction Request (CTR) processing cannot be completed until the outstanding Member Registration Request (MRR) is completed – refer to EDI ID (0011001100) received (01/06/2020) for the MRR details.	Contribution Transaction Request (CTR) processing cannot be completed

[Jimmy801]

Hello @Anonymous 

I suppose you have to tables. In this case just join both table on your error message column and then expand the long description.

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy