how to add data to existing file and how to use LIST properly

0 votes
hello, I am new to talend, I have two ambiguities, I tried to find a way to extract the rows from an excel table or a text file into a list as a temporary variable to then iterate over this list element by element with in a TsendMail component. i could not use list properly .

My second problem is how I can add data below the data already written in a text or excel file, i.e. we always create new files with the data we are processing but can we create the file once then at each iteration we add (modify) lines in the file WITHOUT OVERWRITING its content? :) thank you
Dec 3, 2020 in Talend by aminegac
• 560 points
94 views

1 answer to this question.

+1 vote
Best answer

Hi, @Aminegac

yes, in the output file there's the APPEND option, if you want to add a new line but with the same schema of the other lines that y have inside the file...or if it has a different schema y can make something like:
tFIleInputDelimited---->TMap---->tFileOutputDelimited

answered Dec 4, 2020 by Gitika
• 65,870 points

selected Dec 4, 2020 by aminegac

@Gitika thank you , great answer . i will try both senarios to learn this thing well .

Related Questions In Talend

0 votes
0 answers

How can I use talend to extract data from Oracle and import the data into a MSSQL database?

We currently have around 100 Oracle tables ...READ MORE

Nov 4, 2020 in Talend by umesh
• 150 points
176 views
0 votes
1 answer
+1 vote
1 answer
0 votes
1 answer

Looping through all the schemas in Talend

It is really simple to make tOracleInput ...READ MORE

answered Apr 10, 2018 in Talend by code.reaper12
• 3,500 points
627 views
0 votes
1 answer

Parsing JSON in Talend

While working with JSON files, one thing ...READ MORE

answered Apr 2, 2018 in Talend by code.reaper12
• 3,500 points
1,584 views
+1 vote
1 answer
0 votes
1 answer

How to loading flat file from configuration in Talend?

Hey, @There, Regarding your query you need to ...READ MORE

answered Jun 3, 2020 in Talend by Gitika
• 65,870 points
237 views
0 votes
2 answers

Read Data from Rest API's through Talend and store it in Oracle

Hi, @Abhishek, Regarding your query, I would suggest ...READ MORE

answered Oct 15, 2020 in Talend by Gitika
• 65,870 points
973 views