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.
The first 100 community members completing the Open Studio survey win a $10 gift voucher.
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
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend