Forum Discussion

avitalo1's avatar
avitalo1
Frequent Visitor
6 years ago
Solved

filtering based on custom column

Hello,

I am relatively new to M and am trying to create steps I can apply to various files. I was able to split the columns I needed to split and create parameters. However when I try to filter the relevent information I hav run into problems.

 

I have written the following M code:

Table.AddColumn(#"Replaced Value", "hu and other", each (Table.Contains([Affiliations authors 1] or [Affiliations author last], "Hebrew Univ" or #"other institution") and Table.Contains ([Affiliations authors 2] or [Affiliations authors 3] or [Affiliations authors 4] or [Affiliations authors 5], "Hebrew Univ" or #"other institution")))

 

all of the columns are type text.
I'm getting an error:

Expression.Error: We cannot convert the value " Inst Canc Res, Onco..." to type Logical.
Details:
Value= Inst Canc Res, Oncogenet Team, London, England
Type=[Type]

 

abviously I'm missing something and any help would be much appreciated

 

Thanks

Avital

  • avitalo1's avatar
    avitalo1
    6 years ago

    That makes sense, thanks. I will rethink my approach and see if I can get the results I need.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi,

     

    I think it's because the column values [Affiliations authors 1], [Affiliations author last], ..., [Affiliations authors 5] aren't boolean (this means: true/ false). Since they aren't boolean, you can not connect them with an "or" keyword.

    • avitalo1's avatar
      avitalo1
      Frequent Visitor

      That makes sense, thanks. I will rethink my approach and see if I can get the results I need.