The focus of this first blog will be on one of the most used functions in Excel, the VLOOKUP function. This series of blogs named ‘From Excel to alteryx’ will focus on this transfer and hopefully help others in a similar situtation to myself identify how we can recreate Excel functions in an alteryx workflow. So I am then left with the question ‘well this is how I would do this in Excel, how the hell do I do it in alteryx, it must be possible!’ In every case I have encountered so far, it is! It has changed the way I prepare data hugely. The only problem I have results from the fact that I am so used to doing data preparation in Excel and the syntax it uses that whenever I move through a workflow in alteryx I still think about it with my Excel ‘hat’ on. Since moving to The Data School we have been introduced to alteryx, a data preparation tool that is hugely responsive and easy to use. And like many millions of us I got continually frustrated with how slow it can become when working with large (by excel standards, tiny to others) data sets. Like many millions of us about 3 months ago I was entirely dependant upon Microsoft Excel for data preparation.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |