BusinessObjects Board

how to get text file row count from source in sap bods

Hi Experts,

I have to get row count from flat file source and count should be displayed as print function in the trace log.

Thanks,
Venki


ursfriend77 (BOB member since 2011-03-02)

do an OB/GB on DI_FILENAME and load that to a table, then use a sql statement to select & print it to the tracelog.

or if its fixed width you can calculate it by dividing the file size by the record length.

if its a delimited file you of course have to cross your fingers that the buggy ds reader doesnt stop reading when it encounters an embedded field framing character. “this"is”,“treated”,“like”,“an”,“end”,“of”,“file”


jlynn73 :us: (BOB member since 2009-10-27)