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.
the Alteryx Data Input is eating cells data from an .xls file, Setup as File Format: Microsoft Excel 97-2003(*.xls) . which i don't understand where is it going/being stored.
It throws [Null] values, when it should't, with one direct reading from the file tab. In the pic below, there are the 4 records displayed by the Input data and a screenshot of the original file, I wonder if anyone ever found such issue.
If someone wants to have a look at the file, attached a sample! As this will be part of a more complex automated system, built a macro trying saving into .xslx before, but now i've another issue, as the macro only reads the first row of the sheet :-(
Hi, the question here is, even though saving this file (manually) into a .csv or .xlsx will output all the data in the file, how do i do that in Alteryx, without reading the .xls first? Because i always need to read the .xls first prior to building any file/table.