Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Advance find functionality

Hi   I have the following problem problem to solve. I have two tables. the first one contains email addresses (emails_table) and the second one contains a number of keyworks (exceptions_table).   ...
Need Help
Show and Tell
  • az38's avatar
    az38
    6 years ago

    Hi Anonymous 

    try column

    Column = if(countrows(Filter(exceptions_table;search('exceptions_table'[exceptions];emails_table[email];1;-1)>0))>0;1;0)

    do not hesitate to give a kudo to useful posts and mark solutions as solution

az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

try column

Column = if(countrows(Filter(exceptions_table;search('exceptions_table'[exceptions];emails_table[email];1;-1)>0))>0;1;0)

do not hesitate to give a kudo to useful posts and mark solutions as solution

Anonymous's avatar
Anonymous
Not applicable
6 years ago

works fine. many thanks az38 , top man