internal EDT doesn’t handle column names, it uses just column numbers.
In case you have changing or changing order of columns in input files, create a help file (csv or Excel) which just includes the headers. The first thing you should do before any other action merge the file with the headers (on top of the data file) with the data file using the Stack transaction (align on “Header name”). This will bring the columns every time in an identical order and the following actions should work correctly.
Even if you remove the link from the dataset file to the stack, your transformation that are done on the columns that you have set, will stay intact and any new columns will get added at the end, you then simply rearrange them as you need by using other transforms like Reorder Cols.
Just keep this in mind, that any transform that you do on columns that are not in your header list will lose their settings in the transforms, when you change file or break the link and attach it again to the Stack transform. That is why I said, that make the column header first that you will have or need in your transformation.
Sry for my late answer, I just finished setting up everything for the renaming part. @Olaf, @Anonymous and @Admin thank you very much for the tips, the Stack transformation and the use of clipboard is working like a charm. You guys are the best!!!
@xeokydo Regarding the referencing for the internal number or column header, it would be an interesting and useful feature that changes and expands the use of EDT. The function could fully automate my process and there would be no need for manual changes.