I'm attempting to recreate a query in DI that I'm currently running in EG.
However I'm hitting a brick wall when I try and transpose my data. Simple in EG, seems impossible in DI.
Its a small table
Staff_Division(Char),Week_Commencing(Char),Ave_Work_Lost(Numeric)
Staff_Division and Week_Commencing, with the values never changing and from EG the output looks as follows.
Staff_Division WC_4 WC_3 WC_2 WC_1
Division1 x x x x
Division2 x x x x
Division3 x x x x
Division4 x x x x
where x donates the value that was stored in Ave_Work_Lost.
In EG ive set Transpose Var: Ave_Work_lost
Copy variables: blank
New Column names: Week_Commencing
Group analysis by: Staff_Division.
New Column labels: blank.
I've found the same options within DI, however even with a few hours trial and error trying various different combinations of the above and a few more reading guides I'm no closer to achiving what I need.