topic Re: Help with creating SCD table in App Development

Help with creating SCD table

Xabinav — Sat, 16 Nov 2024 06:57:42 GMT

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

Re: Help with creating SCD table

Gysbert_Wassenaar — Sun, 30 Dec 2018 06:55:55 GMT

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...
    ;

Re: Help with creating SCD table

Xabinav — Sat, 05 Jan 2019 16:37:33 GMT

Thanks !!!