Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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];
I almost done. But i cannot add this expression. Please advise. Thanks.
Error:
Do you have any advise? Thanks.
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];
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,
Thanks Fei Xu.