Loop through rows for multiple reports

[stevens_albert]

Hello, I hope this message finds you well.

I currently have a workflow that takes a .csv file and creates a report. However, I need to be able to create a report for each row in the .csv file. I have looked around and I have seen that the most common nodes for this are the loop and “call local workflow” nodes. I am having a hard time and would really apreciate some guidance.

Is there an example workflow for this that I could use?

Any help is apreciated!

Thank you

-Jorge

[elsamuel]

I have seen that the most common nodes for this are the loop and “call local workflow” nodes

There are lots of loop nodes. Which ones have you tried and what were the results?

[stevens_albert]

Thanks for the reply!

The problem I am having is trying to add the loop end node. Since the “data to report” node does not save the PDF, I do not know where to end the loop.

I have tried the chunk loop node with one row intervals but the loop does not produce separate reports.

I hope this helps!

Thank you

[armingrudd]

Hi @stevens_albert and welcome back to the KNIME forum,

As far as I know, it is not possible to create multiple reports in a loop but you can follow this workaround:

KNIME BIRT (Seperate Pdf pages)

Hi @shubhamss, It’s not possible to export report pages separately. But I have a solution for you: First, you need to put each row of the table in a separate page. To do that select the data row in your table and go to the Properties tab then select the Page Break section and set the value of the “After” option to “always”. Now every invoice goes to a new page. Export the current report into a PDF file and go here to split the PDF file. As soon as the file is splitted, you can save all the s…

[stevens_albert]

Thank you! I was able to do this with no problems!

However, what happens if I need to repeat the rows of multiple tables in one page? I see that this solution will break the page after each individual row no matter what table.

Also, is there a way to repeat graphs for each row?

Thank you very much for your support!

[armingrudd]

@stevens_albert

I need to repeat the rows of multiple tables in one page

Instead of using page break after each row, put it after each table.

[ipazin]

Hello @stevens_albert,

I think it is possible to create multiple reports using loop. Does every report has same format?

Br,
Ivan

[armingrudd]

It seems I’m going to learn something new again!
@ipazin would you please tell me how? Let’s assume that I have a simple table and I have designed the report layout in BIRT. Now I want to generate a PDF file for each row in the table. How should I do that in a loop?

[ipazin]

Hi there,

let me try construct workflow example and share with you next week.

Br,
Ivan

[stevens_albert]

yes, it would have the same format!

[stevens_albert]

thank you very much!

[ipazin]

Hello hello!

Does something like this makes sense?

ipazin/Public – Multiple Reports

There’s no much sense in data and format could be improved but does create multiple reports

Br,
Ivan

[armingrudd]

Fantastic!

Didn’t know we can do that. Always learning from you @ipazin. You are the true master of KNIME.

[stevens_albert]

WOW! This is perfect! I love the group loop feature! I did not know that node existed.
Thank you very much for your help!

[ipazin]

Hello!

You are welcome and tnx. Glad it helped.

Br,
Ivan