Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

SPSS file

Please can anyone help me i really need it

 

 

Load Data into database mysql from file spss

i already do for excel file.

help me please

Labels (4)
6 Replies
Anonymous
Not applicable
Author

Hi
Take a look at the SPSS components and learn the scenario.
https://help.talend.com/reader/1lUpv~2pBEhtc6fvQwPFhw/US~IomevrLc7LZecQZ24nQ

Regards
Shong
Anonymous
Not applicable
Author

oh thank your reply
i think i can already do that
1°) How to dysplay an spss file
2°)how to write in an.sav file

so my question is :
i have an spss fil and i want to integrat the data into MySQL table database
Best regards
Anonymous
Not applicable
Author

Hi
Are you able to read data from an .sav file now? If not, follows the scenario using tSPSSInput component in this documentation page and learn it.
https://help.talend.com/reader/1lUpv~2pBEhtc6fvQwPFhw/aqcDs4HDZ~uySbMUYGRcZQ
After you read the data from .sav file, link the tSPSSInput component to a tMySQLOutput for inserting or updating the data to Mysql database. eg:
tSPSS--main--tMysqlOutput

Regards
Shong
Anonymous
Not applicable
Author

hi i am so happy for your help
so definitely i have an error please look at the files attached

My spss file contains named variables from A to H
I want to put each group of variables in a mysql table
for example (file attached =captureBD)

Best regards0683p000009M97V.jpg0683p000009M9eM.jpg0683p000009M9eR.jpg


erreur.JPG
Anonymous
Not applicable
Author

Hi bayeManel
I have no idea on the NPE error, it is not a job design issue, if you are a Java developer, you can launch the Java debug model and debug the Java code to see if you could find any hits.

0683p000009M9ew.png

Regards
Shong

manodwhb
Champion II
Champion II

tsspinput component is giving null pointer exception..
You need to share the configuration of tsspinput, have you not specified something like host or port or username or password or object name.