Getting an empty line after the header in excel file

[BN1]

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

[Anonymous · Accepted solution]

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.

[BN1]

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.

[Anonymous]

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