Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Filter two different tables

Hi,

I need some help if it is possible.

 

I have a table with data like this

 

Table: data

 

dataNameinfo2info3policyName 
info1.1info1.2info1.3policy1,policy2,policy3 
info2.1info2.2info2.3policy2,policy3,policy4 

 

And I have another table.

 

Table: policyNames

policyName
policy1
policy2
policy3
policy4

 

And I need to filter selecting from the second one and see how many rows from the table data or the column dataName have in them the selected policy.

 

Thank you in advance

1 Reply

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

    Hi,

    In the Query Editor, right click on the PolicyName column of the Data Table and select Split Column > By delimiter.  Select comma as the delimiter and expand Advanced Options.  Select Rows there.  Right click on the column and sleect Trim.  Create a relationship (Many to One and Single) from the PolicyName column to the PolicyName column of the PolicyNames Table.  To your Table visual, drag the PolicyName column from the PolicyNames Table and write this measure

    Measure = countrows(Data)

    Hope this helps.