Forum Discussion

Tieryn's avatar
Tieryn
Regular Visitor
6 years ago
Solved

Filtering a table by a list using text contained within the column

Hi,   I have a column called "textPayload" which is basicaly a license log containing strings such as the below. OUT: "Studio_Runtime" StudioAdmin@license-server   I have also created a list of ...
Need Help
  • Tieryn's avatar
    Tieryn
    6 years ago

    Hey sturlaws - okay thanks, that's helpful information.

     

    Actually - from a completely separate issue I was looking into I think I've found the answer.


    It's probably because i'm importing from BigQuery - but it seems like what was missing was a  

     

    #"Buffer table"= Table.Buffer(#"Filtered Rows"),

     

    After adding this in advanced editor it worked.

sturlaws's avatar
sturlaws
Resident Rockstar
6 years ago

Hi Tieryn 

 

I created a very simple mockup according to your description, and I am unable to recreate your issue, so your code works.

 

As to why you get the error message, are you sure [textPayload] exists in #"Filtered Rows"?

 

 

Tieryn's avatar
Tieryn
Regular Visitor
6 years ago

Hey sturlaws - okay thanks, that's helpful information.

 

Actually - from a completely separate issue I was looking into I think I've found the answer.


It's probably because i'm importing from BigQuery - but it seems like what was missing was a  

 

#"Buffer table"= Table.Buffer(#"Filtered Rows"),

 

After adding this in advanced editor it worked.