I am a newbie to SAP BODS. Currently, i am trying to achieve a task which is as follows:
File paths and File names are maintained in a Config table.
What i want to achieve is to read the data from respective file paths, files which are prescribed in the Config table and load it in to a Target table.
My Config table structure is as follows:
Config_Id - Number (PK)
File_Path - Varchar
File_Name - Varchar
Example: If there are 3 entries in Config table pointing to 3 different files with each file having 10, 30 and 50 records respectively. So, After running the job, the target table should have (10+30+50) records.
Please let me know if such requirement is feasible using BODS. If yes, any direction on this would be of great help.