Posted: Sat Jun 01, 2019 3:10 am Post subject: How to call Multiple Excel files from particular sheet in DS
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.