Forum Discussion

jagarciao's avatar
jagarciao
Frequent Visitor
5 years ago

Replica datos

Hola a todos, 

 

No se como siguiente solucionar este problema, tengo la base, no se genera otra fila hasta que se actualiza el tiquet:

carné de identidadEstadoActualizacion
RFT937474Pendiente26/12/2020
RFT937474Pendiente01/01/2021

 

Requiero que quede de la siguiente forma:

Se agregaron los tres últimos registros con las fechas que correspondan al inicio de la semana del mes, hasta que el tiquet cambie de estado o de fecha de actualización.

 

carné de identidadEstadoActualizacion
RFT937474Pendiente26/12/2020
RFT937474Pendiente01/01/2021
RFT937474Pendiente01/04/2021
RFT937474Pendiente11/01/2021
RFT937474Pendiente18/01/2021

 

Gracias por su ayuda !!!

Need Help

3 Replies

  • AlB's avatar
    AlB
    Community Champion
    5 years ago

    Hi jagarciao 

    You'll have to explain a bit more. There seem to be errors in the dates

    - is  it 01/04/2020 or 04/01/2021 ?

    - 11/01/2020??

    plus it is not clear when to stop. There is no status change in your sample data.

     

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

    • jagarciao's avatar
      jagarciao
      Frequent Visitor
      5 years ago

      Ya se encuentra corregido, el limite lo pone una tabla calendario.

      • v-yingjl's avatar
        v-yingjl
        Community Support
        5 years ago

        Hi jagarciao ,

        Not certain what is your expected output. Did you want to insert rows in the source table which get each start date of week for each month?

        In addition, what did calendar limits this represent? Could you please consdier sharing more details about this issue or a sample report without any sesentive information for further discussion?

         

        Best Regards,
        Community Support Team _ Yingjie Li
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.