Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have table like:
Table:
BatchID, Bach_Name, Time, Timestamp
1, Dental, Start, 10-12-2020 10:15
1, Dental, End, 15-12-2020 6:10
2, Medicine, Start, 12-11-2020 11:15
2, Medicine, End, 17-11-2020 10:30
3, Engineering, Start, 10-10-2020 11:15
3. Engineering, End, 17-10-2020 03:15
;
I need output Like
BatchID, Bach_Name, Start, End
1, Dental, 10-12-2020 10:15, 15-12-2020 6:10
2, Medicine, 12-11-2020 11:15, 17-11-2020 10:30
3, Engineering, 10-10-2020 11:15, 17-10-2020 03:15
;
Kindly help me how to use cross table.
These are no datas for crosstable,
But you can:
Temp:
load * from your datasource;
Data:
load
BatchID,
Timestamp as Start
resident Temp where Batch_Name = 'Start';
left join
load
BatchID,
Timestamp as End
resident Temp where Batch_Name = 'End';
Regards
Hello, here you can find examples on how to use cross tables 😊
When I am using below script, only 'Start' is coming but end is blank.