Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Tengo dos mesas TABLE1 y TABLE2.
Actualmente no hay relaciones entre ellos, pero TABLE1 contiene la fecha y hora de un evento y TABLE2 contiene un StartDatetime y EndDatetime para cada turno. Me gustaría combinar las dos tablas en función de si datetime en TABLE1 está entre el StartDatetime y EndDatetime de TABLE2.
Ejemplo de datos...
TABLA1:
Código de evento | Datetime |
001 | 5/1/2020 2:30:00 PM |
088 | 5/1/2020 6:00:00 PM |
003 | 5/1/2020 11:00:00 AM |
006 | 5/2/2020 4:00:00 PM |
088 | 5/3/2020 8:00:00 AM |
TABLA2:
StartDateTime | EndDateTime |
5/1/2020 6:30:00 AM | 5/1/2020 2:29:59 PM |
5/1/2020 2:30:00 PM | 5/1/2020 10:29:59 PM |
5/1/2020 10:30:00 PM | 5/2/2020 6:29:59 AM |
5/2/2020 6:30:00 AM | 5/2/2020 2:29:59 PM |
5/2/2020 2:30:00 PM | 5/2/2020 10:29:59 PM |
5/2/2020 10:30:00 PM | 5/3/2020 6:29:59 AM |
5/3/2020 6:30:00 AM | 5/3/2020 2:29:59 PM |
5/3/2020 2:30:00 PM | 5/3/2020 10:29:59 PM |
5/3/2020 10:30:00 PM | 5/4/2020 6:29:59 AM |
5/4/2020 6:30:00 AM | 5/4/2020 2:29:59 PM |
5/4/2020 2:30:00 PM | 5/4/2020 10:29:59 PM |
5/4/2020 10:30:00 PM | 5/5/2020 6:29:59 AM |
Resultado deseado:
Código de evento | Datetime | StartDatetime | EndDatetime |
001 | 5/1/2020 2:40:00 PM | 5/1/2020 2:30:00 PM | 5/1/2020 10:29:59 PM |
088 | 5/1/2020 6:20:00 PM | 5/1/2020 2:30:00 PM | 5/1/2020 10:29:59 PM |
003 | 5/1/2020 11:11:00 AM | 5/1/2020 6:30:00 AM | 5/1/2020 2:29:59 PM |
006 | 5/2/2020 4:10:00 PM | 5/2/2020 2:30:00 PM | 5/2/2020 10:29:59 PM |
088 | 5/3/2020 8:33:00 AM | 5/3/2020 6:30:00 AM | 5/3/2020 2:29:59 PM |
Gracias de antemano por cualquier ayuda
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
2 | |
2 | |
2 | |
2 | |
1 |