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.
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