Hi there ,
I have two tables -
where join the two table I am getting the below using the script
EDBreaches:
right keep(WARD_EPISODE)
load WARD & '-'& hour([Arrival DateTime]) as [Ward Episode Arrival DateTime Hours]
,Sum([ETP Denominator] - [ETP Numerator]) as EDBreaches
resident ED
where [Departure Date] >= Date(Today()-29)
group by WARD,hour([Arrival DateTime])
;
But I want the value of Arrival Hour - 0,1,2,3 from the second table after join ?