4 Replies Latest reply: Apr 13, 2018 4:19 AM by ahmad albab RSS

    Transform current data (2 table is joined)

    ahmad albab

      Dear Team,

       

      xxx.PNG

       

      I already combined two table using join. But now i want to transform my data as below. Please help. Thanks.

      xxx1.PNG

      a) Create new line item for each task with created status

       

      b) Create new field "Month_Graph." & assign "Task Created" as its date.