Trying to do something really simple here - rename using “Column Rename (Regex)” I simply want to change the column names to all lower case. Tried many combinations of search (.+) and replacement \L1$ - no joy it does not want to act on the name - it just adds a prefix to it .I have 500 columns so no - do not want to do this one at time. I am assuming I am missing a fundamental piece of info here. Thanks in advance.
seems this is not supported but here you can find workaround:
that is ok in case table is small otherwise you are two times transposing big table which is not necessary and may take some time
Thanks a lot Ivan,
good to know. Would normally do this in Python not with Knime nodes