Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Haidann
Helper I
Helper I

Trasnform Date in Rows to multiple Rows

Hola chicos,

Tengo un conjunto de datos como el siguiente:

hotel_idtime_fromtime_toRegular
73307/1/20198/18/2019114
19739/6/20199/14/2019100
19739/16/20199/19/2019100
19739/21/201912/31/2019100
73309/16/201910/9/2019100
733010/13/201912/31/2019100
19737/31/20199/3/2019100
73308/19/20199/14/2019100
19739/4/20199/5/201999
19739/15/20199/15/201999
19739/20/20199/20/201999
73309/15/20199/15/201999
296208/9/201912/31/201998
35911/3/201912/5/201980
35910/16/201911/1/201980
35912/8/201912/26/201980
35912/29/201912/31/201980
3598/16/201910/14/201980
35912/6/201912/7/201979

¿Cómo puedo transformar el conjunto de datos anterior a la plantilla siguiente:

hotel_idtime_fromRegular
73307/1/2019114
73307/2/2019114
73307/3/2019114
73307/4/2019114
73307/5/2019114
73308/18/2019114
35912/7/201979

Por favor, ayúdeme.

Gracias

1 ACCEPTED SOLUTION
1 REPLY 1
amitchandak
Super User
Super User

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors