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
