Data Validation Doubt

Helannivas — Fri, 26 Jul 2013 09:41:41 GMT

I have one source table(SRC_EMP).For Eg.

Emp_id MICR_No
123 456854778

456 785594145

786 41256257

345 45875

785 748487544

I have one Validation.MICR should be 9 digits.

I want the error records in one table and all the records in another table.(i.e)

ERR_EMP TRGT_EMP

Emp_id MICR_No Emp_id MICR_No

786 41256257 123 456854778

345 45875 456 785594145

786 41256257

345 45875

785 748487544

I have used data validation transformation and but i cant able to achieve my results.

I am getting the o/p as

ERR_EMP TRGT_EMP

Emp_id MICR_No Emp_id MICR_No

786 41256257 123 456854778

345 45875 456 785594145

785 748487544

How to achieve my result?

Kindly help me on this.

Re: Data Validation Doubt

Keith — Fri, 26 Jul 2013 11:04:35 GMT

I'm assuming you're using DI Studio, in which case you should tag the question as such in order to avoid irrelevant answers

Amir — Fri, 26 Jul 2013 11:13:31 GMT

Hi,

How about the following untested code:

data err_emp trgt_emp;

set src_emp;

output trgt_emp;

if length(strip(micr_no)) ne 9 then

output err_emp;

run;

Regards,

Amir.