Hi, I need to know if the csv file which is being processed has header names same as per expected.If the header names are different i need to reject the file.If the header names are same as per schema then the file is supposed to be processed. Please advise how this can be done?
read a first row of the file using tFileInputFullRow component then check first row of the file with tJavaRow using string compare methods like "contains, equals, equals ignore case" and based on compared result you can process file or reject it.
But how to check if the field names are as per expected tFileInputDelimited schema?Or are we supposed to check with hardcoded names?Also how to check only header names matches?And also if valid i want to process the file as tFileInputDelimited
Hi umeshrakhe, Thanks i was able to handle my conditions with your previous solution. And yes tSchemaComplianceCheck does not work with extrat columns.Also it was not validating field names. Thanks a lot, anaya