Modify job - UPPER to LOWER CASE

One Star

Modify job - UPPER to LOWER CASE

Hi all,
i have a problem in my jobs.
The table name and column name used in my jobs are in UPPER CASE and i have to transform these metadata in LOWER CASE.
Does anybody know how to do that quickly without broking my jobs ?
It's forbiden to modify the java code of my job. I try to modifiy the file item corresponding to my job. But when i am viewing the job, there is no change.
Thanks in advance.
Rico
Community Manager

Re: Modify job - UPPER to LOWER CASE

Hello Rico
The table name and column name used in my jobs are in UPPER CASE and i have to transform these metadata in LOWER CASE.

Sorry, I don't understand you well. Can you upload a screenshot to explain your problem?
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Modify job - UPPER to LOWER CASE

Hello, I have same needs.
I have an input Schema with colums names like this :
MY_COLUMN_NAME1
MY_COLUMN_NAME2
MY_COLUMN_NAME3
Is there a component that could convert the column name in output like this :
my_colmun_name1
my_colmun_name2
my_colmun_name3
I know I can edit schema manually, but I have a large amount of tables, and I would like to automate this.
Thanks
Lionel
Community Manager

Re: Modify job - UPPER to LOWER CASE

Hello
There is not a component can do that now, can you report a feature on our bugtracker?
Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

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 3

Read about some useful Context Variable ideas

Blog

Talend Studio Improvements for API Services

Take a look at the Talend Studio improvements for API Services

Watch Now

Data Integration Success Stories

Take a look at some Data Integration success stories

Read