1 Reply Latest reply: Feb 1, 2018 3:35 PM by Marco Wedel RSS

    Expanding table based on row value

    James Eckstein

      Hi all and thanks in advance.

       

      I was to take the following table. Each combination of date and ID should have the number of rows as in the count table.

       

      DateIDCount
      1/1/2018ABC3
      1/2/2018ABC2
      1/3/2018ABC2
      1/1/2018DEF4
      1/2/2018DEF2
      1/3/2018DEF1

       

       

      This following table is my desired result. The combination of Date=1/1/2018 and ID=ABD has 4 rows because the count for this combination is 4 in the table above.

       

       

      DateIDCount
      1/1/2018ABC1
      1/1/2018ABC1
      1/1/2018ABC1
      1/2/2018ABC1
      1/2/2018ABC1
      1/3/2018ABC1
      1/3/2018ABC1
      1/1/2018DEF1
      1/1/2018DEF1
      1/1/2018DEF1
      1/1/2018DEF1
      1/2/2018DEF1
      1/2/2018DEF1
      1/3/2018DEF1

       

       

       

       

      Thanks again!!!