Append Value to Column Headers

Hi guys,

I have a question, How to append value in column header?

Sample Data.

Input Data
Version Column 1 Column 2 Column 3
4
4
4
Output Data
Version Column 1_v4 Column 2_v4 Column 3_v4
4
4
4

Thanks you!

I would use Column Rename (Regex) for this. If you aren’t very familiar with Regex, then you can simplify things by using the column splitter to separate out what needs to be renamed and go with a simple Regex like (.+) to select all of the columns on that branch and then append your version designation to the column names.

(.+)

And the replacement as

$1_v4

3 Likes

Hi @seanmanzanilla

Take a look at this wf. Another approach, no Regex needed. replace_col_names.knwf (26.9 KB).

4 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.