4 Replies Latest reply on Jul 26, 2018 3:08 AM by Shruthi B S

    Query based on data Blending

    Shruthi B S

      Hi Everyone,


      I have a query related to data blending. I have a tableau server data source and another excel spreadsheet hence I'm blending these 2 data sources.

      i have mock up data in attached workbook for reference.


      Here, ID & Qtr(FY Qtr & Inv Qtr are linked) are linking fields. Requirement is that  i want  get Max of FY Qtr & Prev FY Qtr (meaning one less than max) from Primary DS and get corresponding Inv Qtr & Acheivement from Sec DS. From the attached sample, i want below output.


      Inv Qtr        Achievement

      FY18Q4     1468

      FY18Q3      1515