Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
SSV1
Contributor
Contributor

Facing Issue with passing data to python using tSystem.

Dear Forum Members,

Good day all.

Am new to talend.

Am trying to pass data from excel file to tSystem. In turn tSystem will have to pass the excel data which read to python. Output i am getting in python is argument name i am passing not the data.

Sensing how i am passing the argument here is not right. Any help would be great.

ThankYou,

SSV

Labels (3)
2 Replies
willwhitehead
Contributor
Contributor

Hi, SSV,

You're almost there - all you need to do is put the closing speech mark (") before your first plus (+).

 

The string should read: "python /path/to/your/program/ssv.py " + System1.Variable

This field is basically reading Java code, so you just need to close off your initial string before you append your API key 🙂

 

Hope that helps!

Will

SSV1
Contributor
Contributor
Author

Hi will,

 

Thank you for the quick response. But still its having issue and details are listed below.

 

Modified command:

"python /Users/cb-sakthivelu/Downloads/ssv.py" +tSystem_1.API_KEY+

 

And ran the job got below error

Log:

org.talend.designer.runprocess.ProcessorException: Job compile errors 

At least job "ssv" has a compile errors, please fix and export again.

Error Line: 564

Detail Message: Syntax error on token "+", ++ expected

 

Tried to change the code as it was expecting ++ in place of + still getting the issu

 

Modified command:

 "python /Users/cb-sakthivelu/Downloads/ssv.py" ++tSystem_1.API_KEY++

 

Log:

org.talend.designer.runprocess.ProcessorException: Job compile errors 

At least job "ssv" has a compile errors, please fix and export again.

Error Line: 564

Detail Message: Invalid argument to operation ++/--

 

Thank you,

SSV