How to use peek/previous logic to this data?

[arethaking]

Hi ,How to use peek/previous logic to this data?

Thanks in advance.

My source Data:

Requirement to show:

[Anil_Babu_Samineni]

Please share excel file

[effinty2112 · Accepted solution]

Hi Aretha,

Try:

NoConcatenate

Data1:

load

Row,

Month,

if(IsNull(Month), Peek(Month1),Month) as Month1,

ID,

Description

Resident Data;

DROP Table Data;

You can drop Month and maybe rename Month1.

cheers

Andrew

[sunny_talwar]

Another script, similar to Andrew

Data:

LOAD RowNo() as Row,

  If(Len(Trim(Month)) = 0, Peek('New_Month'), Month) as New_Month,

    ID,

    Description

FROM

[Sample Data.xlsx]

(ooxml, embedded labels, table is Data);