topic Re: UpperCase in Talend Studio

UpperCase

Anonymous — Wed, 30 Apr 2014 16:52:37 GMT

Hi,
I would like to knwo how to convert a string ( value in a row ) to uppercase before making an inner join with another value from another table ?
because the first table has a field which is filled with lowercase strings , in the other hand in order to perfor an inner join i have to convert the source'field value to lowwercase
how ca i do this?
Best Regards
Mouad

Re: UpperCase

Anonymous — Wed, 30 Apr 2014 20:01:49 GMT

You should be able to do this in tMap.
The attached image shows a join in the left side of tmap. It converts the field PublisherID from row7 to upper case before comparing it to PublisherID from row 9.
Row7 is the main flow into the tMap. row9 is a lookup flow. I'm not sure how you would convert the row9 value to upper case.

Re: UpperCase

Anonymous — Thu, 01 May 2014 05:52:27 GMT

Alternate way could be to use tjavarow before tmap and convert it to upper case
output_row.your_column= StringHandling.UPCASE(input_row.your_column)
If you want to convert output of row9, then use in tMap Output - StringHandling.UPCASE(input_row.your_column)
Vaibhav