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
3 REPLIES
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