Hey everyone,
I am currently stuck on trying to find a way in which I would input a file and retrieve the appropriate column header names from data within the rows. Due to the reasons below, I unfortunately cannot just "take from first row of data" within the Dynamic Rename tool.
I have the following considerations;
1. year-over-year, the input file rows will change either up or down by just one
2. the "first row of data" across columns are on different rows (e.g. column 1 will have first data on row 1, but another column could have first data not until row 4)
3. Headers are originally blank - so a field info tool does not help as it just lists the columns as "F1, F2, F3, etc"
I am wondering if there is a formula that can be written within the 'dynamic rename' tool in order to run through each column and dynamically grab the first row of data, even if this is a different row for each column. I have tried several if-then formulas, but to no avail so far
Any help would be much appreciated!
And let me know if any support would make this more helpful to visualize, and I can populate some dummy data as an example.
