• Index
  •  » Talend Open Studio for Data Integration » Installation
  •  » Modify job - UPPER to LOWER CASE

#1 2010-01-19 16:20:58

ricole
Guest

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

#2 2010-01-22 03:47:31

shong
Talend team
Registered: 2007-08-29
Posts: 10350
Website

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


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

#3 2010-03-05 10:23:38

lionelbded
New member
Registered: 2010-01-12
Posts: 4

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

Offline

#4 2010-03-08 03:29:41

shong
Talend team
Registered: 2007-08-29
Posts: 10350
Website

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


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Installation
  •  » Modify job - UPPER to LOWER CASE

Board footer

Powered by FluxBB