Hi Team,
I'm an alteryx beginner. I'm facing a problem with renaming my headers.
Consider this sample excel report layout-
| | | | Primary Id | Owner Id | Type |
| Name | Account | Data Type | | | |
| John Smith | Regional | A | 1001 | 1001 | Class A |
| Jane Doe | Global | B | 1002 | 131 | Class B |
| John Doe | Regional | B | 1003 | 435 | Class A |
I am trying to get the header name for my data but the issues I'm facing are-
- Header names are given in 2 different rows instead of first row only. Wherever the header name in given in the second row, the respective column is blank in first row and vice versa (as seen in the sample data above)
- Not all columns are present every time and the order of columns keeps changing, due to this i can't use a text input with header names for dynamic rename as then columns get renamed incorrectly.
- If I just let dynamic rename tool name the columns on the basis of the first row then the columns with their header name in second row get renamed randomly like (Field_SomeRandomNumber) as they were blank. This random header name keeps changing everytime time i update input file with a new report so it is problematic as i need to use filter/formula tool on some of these columns and since its random and changes every time, i run into issue with target names.
Please suggest a solution.
In the attached workflow. Please look at the "Beginning Debt Check" container. I'm comparing report of 2018 with 2019. So set 1 of report is included in package and the 2nd set (to see how the reports vary) is attached externally.
Additionally if you look at how I'm importing data from excel sheets. I'm using three different inputs to import data from 3 different sheets of the same file. How can i do this in one import? I tried searching but since the structure of these 3 sheets isn't the same so most solutions i found didn't work.
