Erroneous final linein csv

[simonB2020]

Am using a file source, tab separated.

After the final line of data, there is one extra line with erroneous data in it.

i.e the data is garbage and breaks the task.

Wondering if there is any way to skip the last line, just as we skip header lines ?

I realise this might be wishfull thinking, but worth a shot ? 😉

[Steve_Nguyen · Accepted solution]

Notes, for file source, you can ignore:

Ignore records:

Header:

Footer:

https://help.qlik.com/en-US/replicate/May2022/Content/Replicate/Main/File/set_up_file_as_source.htm#...

Ignore records

Optionally, specify which header and footer rows in the source files to ignore. Make sure that the header and footer rows to ignore do not contain actual data.