Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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.
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