Forum Discussion
Frune1982
2 years agoNew Member
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
- AnonymousNot applicable