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: No events within the next 45 days.

How to call Multiple Excel files from particular sheet in DS


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



PostPosted: Sat Jun 01, 2019 3:10 am 
Post subject: How to call Multiple Excel files from particular sheet in DS

Hi Experts,

I have a requirement to call Multiple Excel files ( Around 150 Excel files ) and load data into the Teradata table. In each Excel files, we have 3 sheets. I have to extract data from sheet1 and do not want from the rest of 2 sheets. And all files should run one by one automatically while executing the job.

Please help us how can we approach this in SAP BODS. Any help is really appreciated.

Attached the smaple excel file

Thanks,
Veni
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.0260 seconds using 18 queries. (SQL 0.0026 Parse 0.0008 Other 0.0226)
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