Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Sivarapu250
Contributor II
Contributor II

Convert the rows into columns

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.

 

3 Replies
martinpohl
Partner - Master
Partner - Master

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
Specialist II
Specialist II

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


https://help.qlik.com/en-US/sense/November2020/Subsystems/Hub/Content/Sense_Hub/LoadData/work-with-c...

Help users find answers! Don't forget to mark a correct resolution 🙂
Sivarapu250
Contributor II
Contributor II
Author

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