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