Japanese column names in source file

Five Stars

Japanese column names in source file

Hi, I'm using talend open studio DI 6.2 version. My job is simple, tfileinputdelimited-->tmap-->tfileoutputdelimited. The column names(10 columns) in  input .csv file is in japanese, i manually translated the column names form input .csv to english and executed the job. This is a daily job. All the column names in source will be in japanese. Whether there is another way to translate the japanese language column names to english language in an automated manner. I tried to add the japanese language column name in talend, but it is throwing a error. 


Accepted Solutions
Fifteen Stars TRF
Fifteen Stars

Re: Japanese column names in source file

Have a look at the following example which demonstrates how to use tLibraryLoad
https://www.talendbyexample.com/talend-tlibraryload-component-example.html

TRF

All Replies
Fifteen Stars TRF
Fifteen Stars

Re: Japanese column names in source file

Hi,

No, you have to translate by yourself to create a schema where field names are complient with Java namming rules.

 

Regards,

TRF


TRF
Ten Stars

Re: Japanese column names in source file

Do the column names vary, or are they the same on every file?

Highlighted
Five Stars

Re: Japanese column names in source file

Hi, the column names will be same in the text file(daily jobs).
If I'm going to do a Java code for translation, I need to implement Google translator API. So the jobs are going to be complex. Any link available for talend language translation?
Fifteen Stars TRF
Fifteen Stars

Re: Japanese column names in source file

I suggest you to keep the manual translation (for Java complience) and skip the 1st row for each file. I suppose the fields order is always the same for one file, so the cost for something more sophisticate sounds not required.

TRF
Five Stars

Re: Japanese column names in source file

Hi,

As far as i see if i need to convert a japanese language(only header in csv file) to english i need to import a jar file for translating. And need to call the jar file in tjava which needs to be converted in offline.

So under which location the jar file needs to be copied in talend open studio. 

Fifteen Stars TRF
Fifteen Stars

Re: Japanese column names in source file

Have a look at the following example which demonstrates how to use tLibraryLoad
https://www.talendbyexample.com/talend-tlibraryload-component-example.html

TRF

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

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog