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

Question

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

Answer 1

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

Comments

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