I’m enjoying the new reporting features but I’m having a weird result. I’m generating a series of pages using Group Loop->Component-Model Loop End and then using Report Concatenate to put them all together. Each page represent psychometric data on a educational test - one page per item. The items have an integer question number (1 - 50) and also have names as a string in the format “item-001”.
The final report comes out with page orders:
item-001, item-018, item-019, item-020, item-003, item-021 i.e. only very roughly increasing in number. By changing nodes, checking data at various points etc, the misordering is definitely happening after the loop is completed and hence must be at the Report Concatenate (Table) node.
thank you for the positive feedback on the new reporting capabilities…
I tried to reproduce the strange behavior you see, but in my case it worked as expected. Could you share a (minimal) workflow?
The Sorter node before the Group Loop was added while I was trying to work out what was happening (ie ensuring the data was sorted prior).
The Report component generates two single row tables and a graph (all works nicely)
I added a Row Filter just before the Report Concatenate (Table) node to test if it was the issue. If I use that filter to include only, say, the first three rows then it compiles them as: item-001, item-002, item-003 . If I include the first ten rows then item-010 ends up out of order but otherwise the pages match the row order. Let more rows through and it gets more disordered.
However, the disordering is consistent i.e. for the full set the order of the pages is the same every time. I also tried it with page breaks turned off and the order of the items is still wonky in the same way.
[The other component node is just a front page with a static title]
I tried a simpler dummy data set and a simpler workflow. I also used Report Loop End instead of Report Concatenate (Table) to see if that fixes the issues.
So this smaller data does the same idea. One page per test question (named item-0001, item-0002 etc up to item-0020) with a one line table and a graph.
The pages came out in this order:
item-0001
item-0002
item-0011
item-0012
item-0013
item-0014
item-0015
item-0016
item-0017
item-0018
item-0019
item-0020
item-0003
item-0004
item-0005
item-0006
item-0007
item-0008
item-0009
item-0010
Note also that if you edit the example workflow from here CO2 Emissions Report – KNIME Community Hub so that instead of the top 3 countries, the report shows the top 10 countries, they will not be presented in numerical order.
we were able to find a fix for the problem. Thanks again for reporting () it!
If you want, you can grab a nightly version and test it (but please read the disclaimers and use only a test workspace & data): https://www.knime.com/form/nightly-build
Hi @hotzm . I did a very quick test, and the problem (in my particular case) seems to be solved. Tomorrow morning I do some further testing (also to check for any regressions).
. If I include the first ten rows then item-010 ends up out of order but otherwise the pages match the row order. Let more rows through and it gets more disordered.
) it!
You don’t need to wait until the next feature release, since the fix will be part of the 5.2.1 bugfix release.