Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I am trying to ready one excel file which contains some names and formula errors
My requirement is to capture the error records in a reject file and actual records in output file.
But while trying to read the excel file, # DIV/0! disappears and it is considering as empty value in tmap.
Please let me know how to capture this in my reject file.
Say e.g : Below is the field can be considered for my requirement
Bill_ID(Field Name)
A1
101<EmptyValue>
A5
102# DIV/0!
A3
105Hello,
Here is a tSchemaComplianceCheck component which validates all input rows against a reference schema or check types, null-ability, length of rows against reference values. The validation can be carried out in full or partly.
Please refer to this component reference about:
TalendHelpCenter: tSchemaComplianceCheck
Best regards
Sabrina
Thank you...! Component tSchemaComplianceCheck satisfies our requirement