Forum Discussion

LukaszXYZ's avatar
LukaszXYZ
New Member
3 years ago

Filter specific value of the row that has multiple values

Hello,

I have values that are duplicated in different rows, example: 1 recruiter name appears in few rows with another recruiter name.

I'd like to have a filter by a specific name (which will show all values linked with the recruiter), so we don't need to select it multiple times - the problem is that I can't split those columns, because there are only spaces between the names of the recruiters.

 

Do you have any idea how to solve it? 

 

Thank you in advance!

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi,

     

     Not sure if I've got it right but sounds like you need a Text.Contains so you can get every line with that name on it?

     

    let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Primary Recruiters", type text}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each Text.Contains([Primary Recruiters], Filter)) 

    **Filter comes from the below query so users can type in any name they wish to search for but you can hard code "Dave Jones" if you prefer**
    in
    #"Filtered Rows"

     

    let
    Source = Excel.CurrentWorkbook(){[Name="Filter"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Filter", type text}}),
    Filter = #"Changed Type"{0}[Filter]
    in
    Filter

     

    Let me know if thats not quite right