StringDecode

Raftsman · Post by **Raftsman** » Tue Sep 18, 2007 8:57 am

How can I use this routine in my parallel job?

Raftsman · Post by **Raftsman** » Tue Sep 18, 2007 9:09 am

More information...The reason I ask is; in place of using a fileset, I would like to convert the following. Code 1 = 'APR', 2='MAY', 3='JUN', 4='JUL' etc. What is the recomended way to implement this. I wanted to create a routine and call it but I am not a C++ programmer and I am not sure if there another way.

Thanks,

ray.wurlod · Post by **ray.wurlod** » Tue Sep 18, 2007 4:56 pm

Explore the Modify stage, which has lookup_string_from_int16() function.

JoshGeorge · Post by **JoshGeorge** » Tue Sep 18, 2007 10:20 pm

Code: Select all


OutputCol = lookup_string_from_int16[{default_string ='UNKNOWN'} ( 'APR'=1; 'MAY'=2; 'JUN'=3; 'JUL'=4;) ] (InputCol)