Solved! Go to Solution.
Have you select XLSX as an input but the input is actually a CSV? This can happen because most people have CSVs appear as Excel icons on their desktop which can mislead them. I say this because I was able to pull in a sheet with 31 full characters (Excel max for a sheet name) with many of the different symbols you listed below.
Hi Ryan, I've checked the excel file extension. It is XLSX. Just discover that if I change File Format to Microsoft Excel Legacy (*.xlsx), it is able to pick up the sheet name. However, now the option to "Start Data Import on Line" option is no longer available. How can I get Alteryx to pick the data head from row 5 of the excel?
@Joon wrote:Hi Ryan, I've checked the excel file extension. It is XLSX. Just discover that if I change File Format to Microsoft Excel Legacy (*.xlsx), it is able to pick up the sheet name. However, now the option to "Start Data Import on Line" option is no longer available. How can I get Alteryx to pick the data head from row 5 of the excel?
Use the sample tool to skip first four rows, then the Dynamic Rename to take field names from first row of data?
Thanks CiaranA. Tried your suggestion and it works.