Generate Missing Data Multiple columns

zwyne — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Generate Missing Data Multiple columns

sunny_talwar — Tue, 05 Dec 2017 12:48:41 GMT

May be use File Wizard to do this

Re: Generating the missing data with previous data

topic Re: Generate Missing Data Multiple columns in QlikView

Generate Missing Data Multiple columns

Re: Generate Missing Data Multiple columns