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

Register | Login 

Sunset Ride 
Sunset Ride 

General Notice: BOB is going to retire...please see details here. All BOB forums have been converted to "read only" as of September 1st.
General Notice: No events within the next 45 days.

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: 165



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: 573
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 

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0275 seconds using 18 queries. (SQL 0.0022 Parse 0.0009 Other 0.0245)
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