Hi! I have table with ~300 columns like this:
Column1 Column2 Column3 … Column300
I have table with ~300 rows like this:
Old name New name
I need to rename all columns of the first table in accordance with the rule specified in the second table.
Sure I can do it manually but it is too long way. In addition, this is not the only table I need to rename. Is there a faster way to do this?
Thank you in advance!
Sure there is!
Extract column names (Extract Column Header node) and then transpose (Transpose node) them so you have them in one column. Then use String Replace (Dictionary) node. For multiple tables you need loop. But only after you succeed with one table
Play around with it and get back with some errors
Forgot about that one Tnx @izaychik63
Sorry for long feedback. Thanks @izaychik63 for Node I need. It’s perfect decision. Thanks @ipazin for interesting version of decision. I’ll try it later just for experiment and self-study.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.