Forum Discussion

Johannes_W's avatar
Johannes_W
Regular Visitor
5 years ago

CONTAINSSTRING checking multiple inputs

Dear all,   I have a situation I am sure should be possible to resolve, but I can not crack it.   I have several unique processes (A, B, C, D .. ) that have error_ids associated to them, some onl...
amitchandak's avatar
amitchandak
Super User
5 years ago

Johannes_W , Try like

 

new column =
var _cnt = countx(filter(Table1, search(Table1[error_ids], Table2[event_message],,0)>0 && Table1[Process_id] = table2[Process_id]), Table1[Process_id])
return
if(not(isblank(_cnt)), True(), false())

  • Johannes_W's avatar
    Johannes_W
    Regular Visitor
    5 years ago

    Hi! Thanks for this suggestion, but it returns FALSE for me for every row which can not be true.