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
Column1 NewColumn1
Column2 NewColumn2
Column3 NewColumn3
Column300 NewColumn300
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!
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
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.