DSXchange

Hi,

I want to chcek the data type is correct or not.

For example:

I have 2 columns in my source i.e EmpNo(Integer) and EmpName(String).
I want to check the Empno is integer and EmpName is string. How to check these two column data tyes are correct or not.

Is there any other way to check these kind of scenario.

Thanks in Advance...
Aswice

When is a string not a string?

Check out IsValid (if you want to keep processing with a default) and the Column Import stage (if you want to reject invalid records)

Thanks for your reply.

IsValid check is possible to check only the string to string data type. But I want to check all kind of data types check.

Is any other function available apart from this IsValid check funtion.

Thanks in Advance
Aswice

You can use NUM function to check numerical value and Alpha function to check string values.

You can use NUM function to check numerical(integer) value and Alpha function to check string values.

Hi Nirdesh Kumar,

I got it..Thanks for your reply....


With Regards,
Aswice

Gopalraja wrote: IsValid check is possible to check only the string to string data type. But I want to check all kind of data types check.

It is?
Works fine for our float check too...