Forum Discussion

TeeroyinOttawa's avatar
TeeroyinOttawa
Regular Visitor
5 years ago
Solved

Another newbie question: Select Data in one table and filter another table using Contains/find?

Hi all,   This is an extension of my previous post.  I have two tables: AD group and Users.  If a user selects a row in the AD group, I want the Users table to be filtered if the "Member of" column...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    TeeroyinOttawa 

    1. split the member of column

    2. select user name column and unpivot other columns

    3. delete the attribute column and rename the value column

     

    4. create relationships.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

TeeroyinOttawa For this to work you should create a relationship between the two tables then it will work fine as expected.

Appreciate your Kudos, Press the thumbs up button!!👍

Regards,

Husna

TeeroyinOttawa's avatar
TeeroyinOttawa
Regular Visitor
5 years ago

Thanks for your response Husna.  What kind of relationship should I be creating?  Given there are no matching columns to link? (i.e. in table 1 I have AD Group, and in table 2 I have only User Name and Member of (containing the comma delimited values).

 

TIA!

Troy

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    Hi,

    Using the Query Editor, split the entries in the Members of column of the second table to rows.  Then build a relationship between this second column and the single column of the AD Group table.  Build your slicer from the AD Group Table.  To your Table/matrix visual, drag User Name column from the second table.

    • TeeroyinOttawa's avatar
      TeeroyinOttawa
      Regular Visitor
      5 years ago

      Thanks for the guidance Ashish...I'll give that a try.