I've been searching for a way to dynamically rename headers within the Table tool and coming up short. I found a couple of potential solutions, but I wonder if we have anything better at this point (one is from 2019). What I am trying to do is append a date based on a formula to multiple column headers.
I know we could use a Dynamic Rename tool to change the name of the header prior to entering the workflow, but since I'm using a date, the header name would be different every time it hits the Table tool which will put that field at the end of the output vs. the position I want it in. If it's just one field, there's a great suggestion in the article here where you put the "dynamic or unknown" field in the position you want it to appear. Very nice!
We could also use two tables, ignore headers in one, merge, layout and go on our merry way. This looks like the solution I'd need to go with as I have multiple fields on the sheet that need to be updated. This discussion below is from 2019 and provides this solution. It's a great and creative idea and I really appreciate the solution provided, but I wonder if Alteryx might have added some additional flexibility to that tool that wasn't available in 2019?
Has anyone uncovered a way to dynamically rename headers within the Table Tool?