LIST NAME1 COMP1 1 KENNEDY,HOLLY J 0 2 DALE,LUKE 319639 3 DALE,LUKE 0 4 DALE,LUKE 0 5 BIGELOW, RON 319629 6 KOLAR,BARBARA KAY 324095 7 DALE,LUKE 319653 8 DALE,LUKE 0 9 DALE,LUKE 0 10 BIGELOW, RON 319629 11 SMITHEY,ALAN W 324095 12 SMITHEY,ALAN W 0 13 DALE,LUKE 335338 14 DALE,LUKE 0 15 DALE,LUKE 0 16 BIGELOW, RON 319629
I need the following...Basically the zero's replaced with the first non zero value above them... How to achieve this.?
LIST NAME1 COMP1 1 KENNEDY,HOLLY J 0 2 DALE,LUKE 319639 3 DALE,LUKE 319639 4 DALE,LUKE 319639 5 BIGELOW, RON 319629 6 KOLAR,BARBARA KAY 324095 7 DALE,LUKE 319653 8 DALE,LUKE 319653 9 DALE,LUKE 319653 10 BIGELOW, RON 319629 11 SMITHEY,ALAN W 324095 12 SMITHEY,ALAN W 324095 13 DALE,LUKE 335338 14 DALE,LUKE 335338 15 DALE,LUKE 335338 16 BIGELOW, RON 319629This message has been edited. Last edited by: Kerry,
App Studio Version 8202 windows Platform SQL Server 2008/2012
September 29, 2009, 06:22 PM
Darin Lee
how about
NEWFLD/D9=IF FIELD EQ 0 THEN LAST NEWFLD ELSE FIELD;
The "LAST" keyword is what you're looking for.
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat