I want to create a talend job which reads data from a csv file then finds out the children nodes for a column values from redshift table. If children records are present then append those children records to a new csv and then considering these children records as parents finds out if any children nodes are present for these records(like a tree structure). Is there a way to iterate over the nodes till the point where no children nodes are found while appending the data to a csv? In the image from tFilterRow_2 to tMap_5 while writing data to csv using tFileOutputDelimited_2.
