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!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables