Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a table like this:
ID Hour non attendance Working Hours Holydays Hour
BH123 10 56 50
DG566 5 36 32
HJ5632 3 80 36
HU8969 8 70 25
And I need to creat a table IN THE SCRIPT like below:
ID HOUR TYPE Number
BH123 Hour non attendance 10
BH123 Working Hours 56
BH123 Holydays Hour 50
DG566 Hour non attendance 5
etc....
.
.
.
.
Does anyone have an idea please? Thanks you very much
Try like:
Crosstable ( [HOUR TYPE], Number)
Load
*
From <>;
Its working thank you so much