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?
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?
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.