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

ml_andrew's avatar
ml_andrew
Regular Visitor
6 years ago

Hi, Anonymous 

 

I think if you want to create a quick table the best way is to use EXCEPT to create a table

 

EXCEPT('emails_table', 'exceptions_table'), then the output table shall be the one that removes the exception lines. 

 

Thanks

Andrew

  • az38's avatar
    az38
    Community Champion
    6 years ago

    ml_andrew 

    no, except function will except values which equals emails, but not values, whicnh emails contains of (like a substring)

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