How to delete unnecessary line

Unnecessary line breaks are included in the first line of data of the output file.
It seems that line breaks will occur in the course of processing, but I do not know why.
It is hard to review the process, so I'm planning on deleting this unnecessary line break in postprocessing.
Please tell me which tools to use in the workflow.

line.PNG

Workflow

Accepted answers

LJoonas

You could use Sample-tool on the preparation section and on the sample condition pick 'Skip 1st N Records' and choose N as 1.

Other way could be to use filter tool and use a condition that filters every line that has only empty cells on the row.

All comments

BenMoss

Hi!

I wouldn't refer to this as a line break. A line break is when you hit 'shift+enter', I'd just refer to this as an empty row.

As I havn't seen your workflow it's hard to know why this may have been generated. But a simple solution would be to add a filter tool before the output which removes lines where the ID is null or empty.

This can be done with the following condition

!ISNULL([ID])

And then take the true stream and plug into your output data tool.

If this does not solve the issue we would need to see your workflow to help you debug.

Ben

LJoonas

You could use Sample-tool on the preparation section and on the sample condition pick 'Skip 1st N Records' and choose N as 1.

Other way could be to use filter tool and use a condition that filters every line that has only empty cells on the row.

Sakiko

I could solve it by your method. Thank you very much.

Sakiko

Hi Ben,

Thank you again for presenting the solution.
Since my example was wrong, in fact it was not null, I did not use the filter, but it was helpful for future analysis.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703