Loop through rows for multiple reports from 2 tables

[MJRIOUX]

Hello, I have used the great idea that was posted by @ipazin in the workflow below to create a loop that automatically creates one PDF report file for each value in the loop column. Now I’m reaching out for help on how to do the same if I have 2 different tables that need to feed the BIRT report. I’ve attached an example of the workflow.

Thank you for any help!
Mona

ipazin/Public – Multiple Reports

KNIME_LiftLettersLoop.knwf (40.3 KB)

[ipazin]

Hello @MJRIOUX,

but do you still need to create multiple reports like from each row from two sources create one report or something else?

Br,
Ivan

[MJRIOUX]

I need one report for each unique value in the first column called “LiftLetterLoopList”. Each value may have more than one row each in the first table and a different row count in the 2nd table but the value of “LiftLetterLoopList” will be in each table. If you put a filter in for one value before the “Data to Report Nodes” and run the report, you’ll see how the report looks. I need one report like that for each value.

Thank you,
Mona

[ipazin]

Hello @MJRIOUX,

your data can not be seen as workflow is in state reset and files itself are not included within it. (see here for more about sharing data with workflow). If I got it right use Group Loop Start node on first table and use flow variable produced by it to filter matching values from second table in each iteration. Considering you have two sources either put second one in child/called workflow either combine them somehow to send them as one data set and in child/called workflow separate them again if necessary.

Br,
Ivan