Help with creating SCD table

[adimiz123]

Hello
I need your help to create the second table from the first table.
I try to duplicate the dates on all subsequent records, until the next date appears and so on ...

Thanks, Adiel

[Gysbert_Wassenaar · Accepted solution]

Like this for example:

LOAD
    Line,
    CustomerID,
    Alt(IsEnter,0) as IsEnter,
    If(Len(Trim(EnterDate))>0, EnterDate, Peek(EnterDate)) as EnterDate
FROM
     ...source table...
    ;

[adimiz123]

Thanks !!!