Sorry if this sounds trivial but I am just starting with xls formatting and I face one issue and have a question.
I could find some tutorial arguing about the benefit of using the following series: control Table generator (unpivot)-Rule Edit- Control table generator (Pivot) to efficiently tag tables. According to what I have read, the second Control Table Generator node should understand that the input is already a control Table and therefore pivoting back should lead to the original table format with tags in the cells. However in my case, it looks like this second Control Table Generator node treated the input flow as an ordinary table and therefore doesn’t return anything useful to me. Can someone tell me what I do wrong ?
The question is: I have Knime 3.7.2 (latest release available in my company). I have an Excel file with multiple sheets required a different format: can you confirm that with this Knime version, I won’t be able to format all sheets and that the best I can get is the format of only one sheet ?
Thanks to all the community for the support