topic Re: Getting an empty line after the header in excel file in Talend Studio

Getting an empty line after the header in excel file

BN1 — Mon, 17 Sep 2018 22:09:49 GMT

Hi:

Getting an empty line after the header in excel file. Please let me know what options are there to get rid of the empty line. I am attaching the job and the file output as screenshot.Please let me know if you need any details.

Thanks,

Soma

Re: Getting an empty line after the header in excel file

Anonymous — Mon, 17 Sep 2018 23:00:52 GMT

By the look of it you have a tFixedFlowInput to provide your headers and you join that with your data using a tUnite. It shows 3 rows hitting your file. The first row is your header row. Therefore I can only surmise that your second row (or first row of data) is empty. Try filtering your Redshift data or add a filter after your tUnite to remove empty rows.

Re: Getting an empty line after the header in excel file

BN1 — Wed, 19 Sep 2018 18:57:27 GMT

For some reason, although I didn't have empty record, the line came up as blank. I used a tFilter to remove the empty line and that worked.

Re: Getting an empty line after the header in excel file

Anonymous — Sun, 30 Sep 2018 09:46:25 GMT

Hello,

Here is an option called "Trim all columns" in advanced setting of tfileinputexcel component. It can be used to trim the leading and trailing white space.

Best regards

Sabrina