DSXchange

Hi,

My Input is A Column Length of 16 ..I need to do a look up.The lookup column length is 20.

I have to change the lookup column length from 20 to 16 in the modify stage. then i want to perform the lookup.

Can you please tell me the syntax of how to do that in MODIFY STAGE in the specification.

Thanks in Anticipation

Try:

stringField=substring(string,
starting_position, length)

Where stringField is the output column and string is the input column.

Changing the length from 20 to 16 might truncate the data in the field. And also logs a warning. Better option would be to change the length of your main link field to 20 from 16.