UpperCase

One Star

UpperCase

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
Highlighted
One Star

Re: UpperCase

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.
Four Stars

Re: UpperCase

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog