0 Replies Latest reply on Dec 3, 2018 3:41 PM by Shijin Solomon

    How to blend and join on dates from two different extracts related to third primary/driving extract which has no date relationship?

    Shijin Solomon

      Hi All, I am using three different tableau extracts published on tableau server to build visualization for my use-case and data required to build the dashboard is available in these three extracts as shown below

       

      Extract 1 (Primary/Driving extract)-  Has attributes and ids which links extract 2 and extract 3

      Extract 2 - Has business date and other attributes to be compared with extract 3 ids which has relationship established using extract 1

      Extract 3 - Which is a copy of extract 2 which has business date and attributes to measure to values against values in extract 2 which has relationship established using extract 1.

       

      Sample data from each extract:

      Extract 1: (Driving extract/Primary Extract)

      ID         Related ID  

      100       200

      101       203

      102       203

      103       204

      104       205

      105       206

       

      Extract 2: (has both IDs and Related IDs but using to get amt corresponding to IDs from extract 1)

      ID          Date                         Amt1       Amt2

      100        30-Nov-2018           100          200

      101        30-Nov-2018           120          210

      102        03-Dec-2018           127          220

      103        03-Dec-2018           125          240

      101        03-Dec-2018           130          330

      100        03-Dec-2018           144          320

      ...

      ...

      200        03-Dec-2018           125.5       241

      203        03-Dec-2018           132          330

      204        03-Dec-2018           140          340

         

       

      Extract 3: (has both ID and Related IDs but using to get amt corresponding to related IDs from extract 1 and compare with Extract 2 amts for the same date)

      ID          Date                         Amt1       Amt2

      200        03-Dec-2018           125.5       241

      203        03-Dec-2018           132          330

      204        03-Dec-2018           140          340

      ...

      ...

      100        30-Nov-2018           100          200

      101        30-Nov-2018           120          210

      102        03-Dec-2018           127          220

      103        03-Dec-2018           125          240

      101        03-Dec-2018           130          330

      100        03-Dec-2018           144          320   

       

      Since Extract 1 is primary or driving extract and does not have Date attribute which needs to be joined in Extract 2 and Extract 3 to fetch data for same date/s. Is it possible to establish relation between the dates from the non-primary extracts and create one date parameter which allows to filter on one date at a time?