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 used what you linked to before and amended it. It worked ok I think. I may have needed to tweak a couple of things. I was using it to help with an Alteryx trial, which has now expired, so no need for it any longer. Very nice tool which was easy to use and perfect for the Covid data kind of task. Given the trial has expired I am now evaluating the Excel-based options to compare, given they are free to use if you already have Office365.
Great!!! If you allow me to add a comment, from a reporting perspective I think Excel and Alteryx may have very similar capabilities (vlookups, Joins, transpose, crosstab, etc) and this works fine, but in my personal experience we found some deficiency while using Excel when using large files, or when having different Files Types because we need to convert everything to an Excel "Type" format so we can cross reference Datasets and finally for the Data accuracy in Alteryx it is easy to identify visually how the data is coming form the source, like leading or trailing spaces, null values, blanks, unique values, etc.