Several value types in same column

[ipazin]

Hello there!

For such cases following approach is mostly ok:

1. use Unpivoting to have all columns in one column
2. apply rules
3. use Pivoting to have your original table structure

Here is workflow.
Column loop II_ipazin.knwf (69.7 KB)

@andrejz

The second problem is that with column name as flow variable the rule engine node in the loop does not give the same result as the rule engine outside the loop (without flow variables).

Flow variable holding column name doesn’t reference column values in Rule Engine node.
See here:

Basic Question about Column Looping and string manipulation

Hi, I’m trying to clean up some text in an excel file. I can use string manipulation to replace “\r” for any single column in the file. I’m having trouble using column list loop start/end and loop variables to make the manipulations on every column in the file. I’m choosing to replace column, so simply replacing the column name in the serial flow with the $${ScurrentColumnName}$$ in the loop results in a file where every row value is replaced by the column name. I’m missing some basic understand…

And check this workflow:

Looping over all columns and manipulation of each – knime

Br,
Ivan