Hi jlolling, Maybe i did not explain very well. but see the picture below this is what i want to do. i have draw the lines with photoshop for now to show you what i want i did not succed to create this in Talend Open Studio The Iterate flow Component to multiple Mysql_input component is no problem. But if all the Mysql_input Component connect to a tmap after then its not possible.
Simply erase all DiscountLevel_x inputs except the first one and select the iterate flow and take a look at the settings. Here you can find the Execute in parallel option. This will start (per default 2) threads running the query.
All DiscountLevel_x are different queries and different tables 1. output of the First sigIds(Mysql_input Component) are 5 Rows (GroupIds, Percentage) which will be Iterate. 2. Every iterate will pass the GroupId and Percentage to the DiscountLevel_x Mysql_input component (Parallel to 4 queries) 3. After all 4 queries has run (discount calculation has finished) it must be join(tMap) to save it in another table. Data: