Hello everyone, I'm facing a problem in a project that I would like to do in NiFi and I would need some help to it. I have in a Database two tables, one with the name of a client and its ID, and the other with all the information about each client. What I want to do is to retrieve all the information related to each client and put it into a new table that contains all the data from the clients. The steps are the following: 1. Connect to the database and query the table to obtain the clients ID. 2. Take the first ID, query the other table to retrieve the data and put it into the new table. 3. Go through the following client ID until it finishes. I have done previously some dataflows for copying one table and paste into another, but not to query a table, store its value and use in another query using a loop, so I'll be really grateful if someone could help me. ... View more