3 Replies Latest reply on Sep 6, 2018 10:03 AM by Shinichiro Murakami

    Data Blending Using Contains

    Drew Upah

      Hi All,

       

      I am having an issue listing dependencies when it comes to building a Gantt Chart in Tableau. Essentially I have the following data set:

       

        

      TaskDependency
      MYP41
      MYP42MYP41
      MYP43
      MYP44MYP41, MYP42
      MYP45MYP41, MYP42, MYP44
      MYP46MYP41, MYP42, MYP43, MYP44
      MYP47MYP51
      MYP48MYP51, MYP52
      MYP49
      MYP50
      MYP51
      MYP52
      MYP53

       

      What I would like is to use the Contains function and have a list of Task that are dependent. For example a final product should look like this:

       

        

      TaskDependency
      MYP41MYP42, MYP44, MYP46
      MYP42

      MYP44, MYP45, MYP46

      MYP43MYP46
      MYP44MYP45, MYP46
      MYP45
      MYP46
      MYP47
      MYP48
      MYP49
      MYP50
      MYP51MYP47, MYP48
      MYP52MYP48
      MYP53

       

      Anyone know a Contains function that I could use for this?

       

      Thank you,

       

      Drew