Generate Missing Data Multiple columns

[zwyne]

Hi there,

PFA,

I receive daily Excel file from SAP which has the format as attached. So I would to propagate a value from above record to the current one for all fields dynamically(I have +- 20 fields). I can populate them one by one, but I would like to find if there is a smarter way i.e a loop to do this.

I have populated three already by using this syntax : If( IsNull( Vendor ), Peek( Vendor ), Vendor ) as Vendor .

Please advise

[sunny_talwar]

May be use File Wizard to do this

Re: Generating the missing data with previous data