Saturday, February 25, 2012

Different Length input records

Hey, all!

I have a question. I have two different kinds of inputs, and one has a length of 742, while the other has a length of 726. Is there a quick way to check the lengths using the conditional split transformer to send them down different paths?

Thanks!

Jim Work

Sure,

use the LEN function. somthing like LEN(COLUMN)=742 and LEN(Column)=726

|||Thanks!

No comments:

Post a Comment