7 Replies Latest reply on Dec 12, 2018 5:05 AM by Zhouyi Zhang

    Filter Data Source With Cross DB Join

    Michael Patterson

      Hey fellow tabbers,

       

      I've been searching for the longest, but not able to find any previous posts that addresses my scenario/question.

       

      Is it possible to do a filter to just ONE data source while on the Data Source connection tab?

       

      Example. Table A will hold/retain all it's records, but Table B should have filter to exclude say employees from a particular department.

       

      I understand you can leave them separate and do a blend afterwards and also apply filter there, but I'm looking at a scenario where we need to join back to same data source (think parent child relationship) and create/use calculations with some LODs to handle the expected "duplicates". As we all know by now, there are certain limitations with using LODs in Blends so Cross DB join seems to be the better alternative.

       

      Thanks for your guidance.

       

      Regards,

      Mike