Hello, I have a problem matching unnamed columns (using “Stack”) and I can’t use “Rename” because I want to run this with a batch file without knowing the order of the columns in the input files. However, each unnamed column is preceded by a named column that it is matched with. If I were to run a “Stack” based on column name, the unnamed data from set A and set B would be mixed because they are both in column “2”.
Is there a way to programmatically rename columns based on the preceding column? Or are there any other ideas on how to resolve this?
Sample Input Data 1:
Sample Input Data 2:
Desired output after stack: