Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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... ;
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... ;
Thanks !!!