Forum Discussion

Einomi's avatar
Einomi
Helper V
4 years ago
Solved

Text.Contain or List.Contain

Hello   I have the following column in my table   Description Hello AADF 456 Hello GTYH 456 Hello AADF 987 Hello GTYH 987   I would like please a M code to be able to identify...
Need Help
Tips and Tricks
Tutorial Requests
  • ronrsnfld's avatar
    ronrsnfld
    4 years ago

    If you are looking for multiple words in a column, and then outputting a code, the "best" way to do that probably depends on the nature of your actual problem.

     

    One "simple" method is with a Custom Column using List.ContainsAll:

    if List.ContainsAll(Text.Split([Description]," "),{"Hello","456"}) 
   then "H1" 
   else if List.ContainsAll(Text.Split([Description]," "), {"Hello","987"}) 
   then "H2" 
   else null

    However, if you have many possible combinations, using a lookup table approach might be more flexible.

Einomi's avatar
Einomi
Helper V
4 years ago

Hi, AlexisOlson 

 

I am sorry for the delay, I did not get notifications of your answer.

 

If in my column [Tableau C_0. Transaction Description] we have the string "Hello" and the string "456" then H1

 

 

I am attaching a picture of my M code, I am not sure if I managed to work it out with your code