i have table in knime, sometimes it has 5 columns , sometimes 7 columns, and every time i want to create report i have errors. Is there any way to create dynamic table, so i don’t need to change number of columns inside birt report ??
really sorry for the late reply.
This is a little bit tricky, as this needs two steps.
- Unpivot your data into a single column with the /Unpivot node
- in BIRT you need to create a CrossTable generate the width based on the ColumnNames.
I made a very small example here:
Hope this helps! Iris