Author Archives: Daniel Kresina

Converting Data Types in Alteryx

One of the most common tasks in any ETL project is converting data types.  When data begins in the form of a text file or (even worse) a formatted excel file, one often has to load the data as text … Continue reading

Posted in Alteryx | Tagged , | 2 Comments

How to Increment in Alteryx

While Alteryx has many great functions right out of the box, I realized one thing they’re lacking is an increment function (or at least I haven’t found one).  Anyone who’s worked with SQL is familiar with the Identity data type … Continue reading

Posted in Alteryx | Tagged , | 5 Comments

Dynamic Filters in Alteryx

One common task most analysts encounter is the need to setup dynamic filters in their data workflows.  In SQL this is usually accomplished via a sub-query which is joined in to a main query.  In Alteryx, where each step is … Continue reading

Posted in Alteryx | 2 Comments

Key Reasons I Tried Alteryx

I thought I’d start off with an overall review of the Alteryx ETL tool and why I chose to give it a try. If I had to summarize it in one word (well …two) it would be Easy/Productive. I’d tried … Continue reading

Posted in Alteryx | 3 Comments

Post #1 of …

Hey everyone, this is post number one with many more to hopefully come soon.  Check out my bio to get a little background on myself.  I work with all kinds of data every day and hope to post helpful tips … Continue reading

Posted in Uncategorized | Leave a comment