I agree. Bad layout.
For your problem use R in Knime
format_column_name ← function(column_name) {
Pattern matching “OrgL” followed by one or more digits, and “Code”
pattern ← “OrgL(\d+)Code”
Replace the matched pattern, adjusting the replacement to include the captured group digit
new_name ← gsub(pattern, “Level \1 Code”, column_name)
return(new_name)
}
Apply the function to each column name
colnames(df) ← sapply(colnames(df), format_column_name)