check the presence of required fields and format of fields

[Pagadrai]

I need to check the presence of required fields and format of fields.

I tried by len(record) = length of record given in the metadata, but it doesn't work, also i tried using DCOUNT(record,'000'),it works for 05 Records but not for 10 and 15 type.

Hi Arun,
Can you provide more details about the file format -
Any delimiters
How many fields are there and
what format are you validating?

What is the purpose of DCOUNT here ?

[v2kmadhav]

if your trying to fit each type of a record into a consistent metadata...

you can read the file as a big varchar field....

split them into type based on first two values like you tried
and
then analyse if they can be delimited or treated as fixed length...

either after writing a set of substring derivations within the same job
or
into two sequential files each for type 05 and type 10 and write seperate jobs.

[arun@sinmax]

I seperated the fields as you mentioned in the previous posts,but i need, how to check the presence of required fields and format of fields.

Suppose in the record a value for a column is mismatching with the metadata given, i should reject the entire flow for that i need to find the invalid records.


Thanks & Regards,
Arun

[ray.wurlod]

Use stage variables for the target of your parsing, and detect whether each is populated.

[arun@sinmax]

Hi Ray,

Thanks for your reply,

How to find, whether each field is populated correctly or not

Thanks & Regards,
Arun

[ray.wurlod]

Create more stage variables whose derivation expression tests the business rule(s) applicable to each of the first set of stage variables.