Rename new columns in a loop for joiner


I’m working on a project where I have to open raw materials from finished products using information from SAP. As we have several amounts of intermediate products I have to use this codes to re-open SAP information until I get raw materials. In this process, I can’t run the loop because column name changes.

So, my question is: How can I rename columns generated to add a number for old Material Code (Currently Mat Code, want to change to Mat Code 1) to have new column as Mat Code and continue running the loop?

Thank you for your help!!

I don’t completely understand what you are trying to achieve. What kind of loop do you run and what does the data look like? Can you maybe attach a screenshot? Generally you can use the Column Rename node:

Or Column Rename (Regex):

For renaming columns. Does that help?
Kind regards

Hi there @jl1004,

not sure I understand as well. I have seen you opened another topic couple of days ago and seems it is regarding same project.

In my experience best way to get help (suggestions, ideas and example workflows) is to share data (doesn’t have to be real one, it is enough to represent real data) and explain you process well if not obvious.

Hope this helps and you get help for your project :wink:


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