regarding function used in transformer stage

vijaykumar · Post by **vijaykumar** » Mon Dec 18, 2006 4:30 pm

hi,
i wanted to change the values in column ename into lower case letters.
i have a column
ENAME
VIJAY
VII
VICT
i want to change all the values in my column ENAME into lower case.
for this in the transformer stage i used
downcase("%ENAME%")

iam getting the o/p data in the form
ENAME
%ENAME
%ENAME
plz help me, instead of changing into lower case, its replacing the names and printing %ENAME in these columns.
plz help me
cheers;
vijay

us1aslam1us · Post by **us1aslam1us** » Mon Dec 18, 2006 4:34 pm

I think it should be

Code: Select all

downcase("Linkname.ColumnName")

Sam

I_Server_Whale · Post by **I_Server_Whale** » Mon Dec 18, 2006 4:46 pm

us1aslam1us wrote:I think it should be
Code: Select all
downcase("Linkname.ColumnName")
Sam

It SHOULD be as said by Sam. Otherwise, you are passing a hard-coded string.

Whale.

kumar_s · Post by **kumar_s** » Mon Dec 18, 2006 4:59 pm

All most all functions that you choose from transformer will have % to indicate to pass parameters. You need to pass Column name or any String within qoutes as input.

vijaykumar · Post by **vijaykumar** » Mon Dec 18, 2006 4:59 pm

hi gurus,
thanks very much.

when i use downcase(linkname.columnname)- iam getting the actual result.

thanks very much.

cheers;
vijay

ray.wurlod · Post by **ray.wurlod** » Mon Dec 18, 2006 9:03 pm

Please mark the post as resolved. Note that Sam's solution is slightly incorrect - the reference to the input column must not be quoted.

us1aslam1us · Post by **us1aslam1us** » Tue Dec 19, 2006 9:42 am

Yes Ray thats done in a hurry.

Sam