Remove header white space delimited file

[Anonymous]

Hello all,

I have a csv file with headers such as "emp id", "location address" and so on. I need a way to remove these whiter spaces so that I can run the job through tMap. I am pretty new to Talend there is no one here who can help.

Also, the file name will continuously change with a timestamp appended to it.

Thanks

[TRF]

Do you plan to have dynamic schema?

Else, you don't have to worry about the fileds name in the header.

Just ignore the header where reading the file.

For the 2nd point, if you don't know the filename when the job starts, you need to use tFileList with a filemask to get the desired file (I suggest you to rename or move the file when the job finishes).

[Anonymous]

It will not be dynamic. How do I go about ignoring the included first-row header?

[TRF · Accepted solution]

Set the header field to 1 in the basic settings tab for tFileInputDelimited component

[Anonymous]

When I did that, tMap was erroring.

[TRF]

share your job + tMap configuration + error

[Anonymous]

It is a simple tFileInputDelimited->tMap->tFileOutputDelimited where I am mixing around the columns.

[TRF]

Share the pictures else I can't help you anymore

[Anonymous]

Oaky. I will have to do this after my morning 2 meetings. I have to break these out of something bigger and do some renaming prior to posting. There is too much confidential info being displayed currently.

[Anonymous]

Hello,

Elaborating your case with an example with input and expected output values will be preferred.

Feel free to let us know if there is any problem for you to upload your job setting screenshots into forum.

Best regards

Sabrina