BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: Upcoming Events: PGHBOUG: Nov 1.

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


 
Search this topic... | Search DI: Designer and Job Design... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Author Message
ursfriend77
Principal Member
Principal Member



Joined: 02 Mar 2011

Posts: 163



PostPosted: Sun Jun 02, 2019 7:19 am 
Post subject: 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
Back to top
jlynn73
Forum Associate
Forum Associate



Joined: 27 Oct 2009

Posts: 570
Location: DesMoines Iowa


flag
PostPosted: Tue Jun 04, 2019 2:50 pm 
Post subject: Re: how to get text file row count from source in sap bods

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"
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0278 seconds using 17 queries. (SQL 0.0026 Parse 0.0009 Other 0.0243)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo