Re: Convert the rows into columns - Qlik Community

Sivarapu250 · ‎2021-02-25

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.

martinpohl · ‎2021-02-25

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

Patricia_Silva · ‎2021-02-25

Hello, here you can find examples on how to use cross tables 😊

Help users find answers! Don't forget to mark a correct resolution 🙂

Sivarapu250 · ‎2021-02-26

When I am using below script, only 'Start' is coming but end is blank.