1 Reply Latest reply on Oct 29, 2012 8:22 AM by Jonathan Drummey

    filter action on blended tables

    Philip George

      Hi,

      I have 2 datasources.and I am doing datablending.the reason I am doing datablending is that to avoid 1:N join issue.

       

      lets say I have one field Name in first table(Name is unique) and I have Name in second table(Name is not unique).I set the relationship based on Name in two sheets for blending.

       

      In my first sheet I am taking data from first sourcedata only.Name field is present in this.

      In my second sheet I am taking data from second sheet only.

       

      Can i apply a filter action which will give the result as below.

       

      If I click on Name in first sheet(from first datasource) it should redirect to second sheet(this is from second datasource) where it should give the values filtered for that particular name.

       

      Can anyone explain how to achieve this.

       

      Regards,

      Philip