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:
| CA | CB | ||
|---|---|---|---|
| 05:43.0 | 1 | 05:43.0 | 10 |
| 05:43.1 | 2 | 05:43.1 | 20 |
| 05:43.2 | 3 | 05:43.2 | 30 |
| 05:43.3 | 4 | 05:43.3 | 40 |
Sample Input Data 2:
| CB | CA | ||
|---|---|---|---|
| 05:43.4 | 50 | 05:43.4 | 5 |
| 05:43.5 | 60 | 05:43.5 | 6 |
| 05:43.6 | 70 | 05:43.6 | 7 |
| 05:43.7 | 80 | 05:43.7 | 8 |
Desired output after stack:
| CA | CB | ||
|---|---|---|---|
| 05:43.0 | 1 | 05:43.0 | 10 |
| 05:43.1 | 2 | 05:43.1 | 20 |
| 05:43.2 | 3 | 05:43.2 | 30 |
| 05:43.3 | 4 | 05:43.3 | 40 |
| 05:43.4 | 5 | 05:43.4 | 50 |
| 05:43.5 | 6 | 05:43.5 | 60 |
| 05:43.6 | 7 | 05:43.6 | 70 |
| 05:43.7 | 8 | 05:43.7 | 80 |
