topic Re: Convert the rows into columns in QlikView

Convert the rows into columns

Sivarapu250 — Thu, 25 Feb 2021 15:20:08 GMT

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 — Thu, 25 Feb 2021 15:24:03 GMT

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 — Thu, 25 Feb 2021 15:24:28 GMT

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

Sivarapu250 — Fri, 26 Feb 2021 06:23:02 GMT

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