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   dataName info2 info3 policyName   info1.1 info1.2 info1.3 policy1,policy2,policy3  ...
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.