i need to use a loop end (2 ports) but i want one of ports works like loop end (column appender)
anybody can help me ?
I suggest using the normal Loop End (2 ports). To the output that you want to Column Append, use the Constant Value node to add a single String column with the intended column header for that loop iteration. Then, apply a Pivoting to this table.
no Unpivoting node this time?
@ipazin yeah I thought about it until my brain hurt, but I could not find a way to include an Unpivoting node in my suggestion
Thanks for the reply @Aswin
I used your suggestion but it does not work, please provide a workflow example
An example workflow is in the attachment. The essential part of the workflow is this:
The second input/output port of the Loop End corresponds to a Column Append, if it is used in this way. The Pivoting node should be provided with a column containing the future column header and a column with the future row id.
KNIME_project3.knwf (24.1 KB)
The other options is, of course, to simply use Transpose:
…but this only works well if your table only contains a single type.
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.