topic Re: How to exclude hidden rows in a excel source while loading data to sql using talend in Talend Studio

How to exclude hidden rows in a excel source while loading data to sql using talend

Anonymous — Tue, 18 Jul 2017 12:47:07 GMT

Hi All,

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

Re: How to exclude hidden rows in a excel source while loading data to sql using talend

TRF — Tue, 18 Jul 2017 13:23:41 GMT

Hi,

Don't think it is possible with standard tFileInputExcel component.

May be using Apache POI-HSSF / POI-XSSF library.

Hope this helps.

Re: How to exclude hidden rows in a excel source while loading data to sql using talend

Anonymous — Tue, 18 Jul 2017 17:29:41 GMT

Hi TRF,

Thanks for the help.

I have one more question? Is this library can be included as component in talend process.

Re: How to exclude hidden rows in a excel source while loading data to sql using talend

Anonymous — Tue, 18 Jul 2017 17:32:30 GMT

Hi TRF,

Thanks for the help.

I have one more question? Is this library can be included as component in talend process.

Re: How to exclude hidden rows in a excel source while loading data to sql using talend

TRF — Tue, 18 Jul 2017 19:28:35 GMT

You can include the library as "any" external library, then use the proposed methods in tJava family components.
Not so easy and direct as dedicated components but can be useful when you need to control details not available elsewhere.