topic Qlikview - Change data model in QlikView

Qlikview - Change data model

alexandermllr — Fri, 08 Jun 2018 14:01:58 GMT

Hello,

I need to change my database model, this is my data right now:

I need a table like this:

How can I change the data in Qlikview?

Thank you for you help!

m_woolf — Fri, 08 Jun 2018 14:06:41 GMT

Use Peek or Previous

Anonymous — Fri, 08 Jun 2018 14:35:04 GMT

Hello, Alexander Müller!

Is this what you are looking for?

Data:

Load *

Inline

[ID, departure, arrival, Place

5567, 16.04.2018 08:30, , Place 1

5567, 16.04.2018 08:42, 16.04.2018 08:42, Place 2

5567, 16.04.2018 08:45, 16.04.2018 08:45, Place 3

5567, 16.04.2018 09:16, 16.04.2018 09:16, Place 4

5567, 16.04.2018 09:38, 16.04.2018 09:38, Place 5

5567, 16.04.2018 10:46, 16.04.2018 09:40, Place 6

5567, 16.04.2018 11:00, 16.04.2018 10:59, Place 7

5567, , 16.04.2018 12:12, Place 8

];

FinalData:

Load ID,

departure,

FieldValue('arrival',RowNo() + 1) As arrival,

Place As Place_From,

FieldValue('Place',RowNo() + 1) As Place_To

Resident Data

Where Len(departure) > 0;

Drop Table Data;