1 Reply Latest reply on May 9, 2019 2:46 PM by Deepak Rai

    Pivot or Impute Range Data into Separate Rows

    Benjamin Yoder

      I have been using Tableau Prep, but I haven't found a way to do exactly what I am looking to do. I have data with a row level for an account ID. There are 3 columns: one is start date and one is end date and one is number of days. What I would like to do is make it so that each account ID has a row for each day. So for account 1 to have a start date of 5/9/19 and length of 2 days and end date of 5/11/19 I want rows that look like this:

       

       

      AccountDate
      15/9/19
      15/10/19
      1

      5/11/19

       

       

      Is this possible? Thanks.