Transform current data (2 table is joined)

[Anonymous]

Dear Team,

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

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

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

[Anonymous]

I almost done. But i cannot add this expression. Please advise. Thanks.

Error:

stalwar1

Do you have any advise? Thanks.

[NZFei · Accepted solution]

When you use sum() or count(), you need to add group by!

Created:

load

    ....

    .... as Total

resident owssvr

group by Temp, month_created, [PSR No];

[PrashantSangle]

try like

load temp,

     id_no,

     'created' as status,

     task_created as month_graph

from tablename;

concatenate

load temp,

     id_no,

     status,

     task_modified as month_graph

from tablename;

regards,

[Anonymous]

Thanks Fei Xu.