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
How To Change the Length Of a Column In ModifyStage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 4
- Joined: Fri Sep 05, 2008 1:07 am
- Contact:
How To Change the Length Of a Column In ModifyStage
Thanks,
Ramakanth
Ramakanth
Re: How To Change the Length Of a Column In ModifyStage
Try:
stringField=substring(string,
starting_position, length)
Where stringField is the output column and string is the input column.
stringField=substring(string,
starting_position, length)
Where stringField is the output column and string is the input column.