tSPSS with a "." (dot) in column name

One Star

tSPSS with a "." (dot) in column name

Hello,
My problem concerns the tSPSSInput component and a "." in the name of the columns.
With the tSPSSInput component, I try to retreive data from a ".sav" file.
Unfortunatelay, i cannot modify this file, and most of its columns (118/130) have a dot in the name.
Example: TTSE.1, TTSB.1
Here is a sample of the code generated when I link the main output from the tSPSS to a tLogRow:
row1.TTSE.1 = tSPSSInput_1_sr.getDoubleAtPos(114);
row1.TTSB.1 = tSPSSInput_1_sr.getDoubleAtPos(115);
And in the source code:
public String TTSE.1;
public String getTTSE.1 () {
return this.TTSE.1;
}
Java doesn't really like this syntax ;-)
Is there anyway I could override the automatic name of the column in the SPSS schema ?
Or maybe automatic replace the "." of the name by a "_" ?
I Use TOS 5.2.2
Thanks a lot for your help
Community Manager

Re: tSPSS with a "." (dot) in column name

Hi
It should be a bug, it should replace special characters such as "." of the column name with a "_" just as retrieve table schema from database, please report a JIRA issue in the Talend DI project of the bugtracker.
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: tSPSS with a "." (dot) in column name

Ok, I did it.
Thanks
Stephane

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 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog