This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a data set that has a very particular format because of how it needs to be uploaded into the system. There are ~5 column headers that are defined with text, but a number of others that are "blank" and must remain so. Alteryx automagically (ha) created header titles (F10, F11, F12...) which is great for selecting and creating formulas etc, but is there a final step I can impliment before I output the file to revert (or set) those headers to blanks? I tried using Dynamic Rename, which worked... except that it identified the blanks as "duplicate headers" and ultimately renamed them with text as a result.
You can certainly keep those blank headers in your final output back to excel. Take a look at the TABLE tool with the Reporting category.
There you can do an easy rename each header (see below) and make them a blank space. After that you just add a Render tool and choose Msft Excel as your output format.
Now if a SPACE is still too much for your output header format... then you have to use a bit of RegEx (and specifically the RegEx tool and not regex in the Formula tool) and replace all of your Fieldn or Fnwith something like the following: