I have customer data excel files that contain 4 different sheets.
Sheet 1 = Corporate Data
Sheet 2 = Region/Division - Optional
Sheet 3 = Customer Site Type - Optional
Sheet 4 = Customer Locations
Each sheet must be processed in order because of table dependencies.
For example Corporate Data is processed first, unique id’s are created for each line of the file. These Id’s must be added as an additional column on the other 3 sheets in order to load into the database.
If the sheet contains data I want to call a project that transforms the data and then loads to the database
If the sheet is empty I want to continue on to the next sheet and check if it has data and if so transforms the data and then loads to the database etc
How can I do this?