Forum Discussion

Frune1982's avatar
Frune1982
New Member
2 years ago

extract lines in dataset

Hi, 

 

Currently I have several lines in my Bi model.

It is booking data from a holiday park.

In the screenshot below you see 2 bookings:

 

booking1 : from 22 dec 2014 until 02 jan 2015 for 11 nights in chalet 99. Booking was made on 27 august 2014

booking2 : from 23 jan 2015 until 26 jan 2015 for 3 nights in chalet 171. Booking was made on 8 sept 2014

I would like to see a different line for every booked day (=stayed night).

So for booking 1:

22/12/2014

23/12/2014

24/12/2014

25/12/2014

26/12/2014

27/12/2014

28/12/2014

29/12/2014

30/12/2014

31/12/2014

01/01/2015

the other columns should remain the same on every line...

 

Regards, 

 

Fred.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Frune1982  Have you tried unpivoting the below columns in the Query Editor?