How to Check if all the columns are present in the excel file or not before loading into DB?

[Anonymous]

Hi All,

I need to load an excel file to DB , but before doing so , I need to check if all the columns are present in the excel sheet or not.(Table is already present in the DB). 

Thanks,

skp22

[Anonymous]

Hi,

     Please add tschemcheckcompliance component which will segregate data as good and bad based on the rules specified in the component.

https://help.talend.com/reader/KxVIhxtXBBFymmkkWJ~O4Q/NVW3bNLQnpT4TsZS~Qgj7Q

    If the answer has helped you, Could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi