Check presence of header in a file

[RA6]

Hello guys,

Is there a possibility to check if a csv or excel file contain header?

In fact, i want my job to die if there's no header in the corresponding file.

Best regards,

Duke

[vikramk]

Hi @Rohit Aftab​ ,

There is no direct option to achieve this, but you could define the cell reference of header from where you get header name manually in tfileExcelinput component. Then you can validate in tjavarow component whether data is matching with header name, if it mataches, you can implement your use case in next subjob.

Please let me know if it helps

[RA6]

Hello,

Thank you for your reply.

I just got a link (http://talendhowto.com/2017/09/06/check-csv-header-in-talend-open-studio/).

But if the schema of the header is not matching, it ll end the process right?

Best regards,

Duke