Not able to read "#DIV/0!" values from Excel file

[dineshkumare]

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

105

[Anonymous]

Hello,

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

[dineshkumare]

Thank you...! Component tSchemaComplianceCheck satisfies our requirement