topic save tsystem output to file or database in Talend Studio

save tsystem output to file or database

Anonymous — Sat, 16 Nov 2024 04:48:14 GMT

I want to save the output of tsystem to a databse or file

is there anyway to do it in TOS ? (for now it only prints output to console)

here is the python script which tsystem is using

import pandas as pd

data = pd.read_csv('movies.csv')

Anonymous — Mon, 02 Sep 2019 18:08:16 GMT

Adding this to your script should do it, then you could read it back into the job afterwards if you wanted....

import pandas as pd
data = pd.read_csv('movies.csv')
f = open("demofile2.txt", "a")
f.write(data)
f.close()

.....but given what I see in the code, why would you use a python script to read the movies.csv file anyway.....or is it just an example?

Anonymous — Tue, 03 Sep 2019 06:07:08 GMT

this is just an example

akumar2301 — Wed, 04 Sep 2019 19:46:09 GMT

tSystem Output are saved in Global Variable like OUTPUT and ERROROUTPUT( in cqse of error)>

These cqn be helpful in your case