We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Read in Header from Excel file

It would be really helpful to have the ability to read in a Header from an Excel file as part of the Excel file.  I am not referring to column names but the actual Header on the file as this can contain important info to be appended to the data.  This could be an additional checkbox in the Input tool for excel files to read in the header and append to the data as a field.

Currently, a workaround process to do this is to make a copy of the xlsx file and rename as file.zip.  Then unzip the xlsx file and open the sheets as xml files where the headerFooter child element is read in.  Then the header info is appended to the Excel data file which is read in separately in another input tool. 

Would be much more efficient if this was simply a checkbox in the Input Data interface and the Header read in with the data.

2 Comments
Joe_Lipski
13 - Pulsar
13 - Pulsar

Used this same trick to read in the hyperlink URL behind a text field...

 

It would be helpful if there was an easier way to do this!

CristonS
Alteryx Community Team
Alteryx Community Team

thanks for your idea @Dynamomo!