Am using talent DI to load data to SQL server. In my excel source there some hidden rows . These hidden rows not needed to import to my database. Is there any way to do it without setting a flag in source file.?
Don't think it is possible with standard tFileInputExcel component.
May be using Apache POI-HSSF / POI-XSSF library.
Hope this helps.
Thanks for the help.
I have one more question? Is this library can be included as component in talend process.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema