DSXchange

Hi,

Please advice on following situation.

I have a value coming from the source which normally should look like this '20080701' or '20071105' but sometimes they delivered this '20080000'. I want to build a check in the stage variables to exclude these incorrect values. Please advice me how to check only on the last 4 digits? reject when the last 4 digits is 0000.

Thanks in advance

Put a constraint of "RIGHT(In.DateColumn,4)<>'000'"

Tlam wrote:Hi,

Please advice on following situation.

I have a value coming from the source which normally should look like this '20080701' or '20071105' but sometimes they delivered this '20080000'. I want to build a check in the stage variables to exclude these incorrect values. Please advice me how to check only on the last 4 digits? reject when the last 4 digits is 0000.

Thanks in advance

The values was seems to be a date value,first u have to take the last 2 digits by using Right(column_name,2) function & chk whether it is less than 31 & then take the last 4 digits by using Left(Right(column_name,4),2) & chk whether it is less than 12.
Check for both these conditions,if both are not satisfied then reject the records by placing it in a constraint.

Simple could be, in constraint check for Right(column_name,4)=0000, then reject the rows.

Thanks all for your help. I found it as well, i forgot how to search and suddenly realize

If you want to search for "valid date" it's a slightly different approach. Use something like