I want to load an excel file into DB , before that I need to check if all the columns are present in the file or not.
Also I want which column is missing.[column names will be same every time I receive a new file].
Load your Excel file into your job using a preset schema, then test using a tMap to see if all expected columns are populated. Load the results into a tHashOutput. If any column is missing (or holding the incorrect type), either fail the job with a message (using a tDie) or simply do not progress to the next SubJob. The next SubJob will take your data added to the tHashOutput and carry on the processing using a tHashInput to read it back in.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Introduction to Talend Open Studio for Data Integration.