Alteryx Community is the go-to hub for analytics professionals to learn, connect, and solve problems faster. Explore expert-led discussions, product resources, and best practices to build, automate, and scale your analytics workflows with Alteryx.
Here is a new challenge for this week. The link to the solution for last week’s challenge is HERE. The use case: We received some text data and that includes an embedded line-feed character. The objective is to remove the new line character, convert the date-time string to a date-time formatted field and then do some…
The solution to last week's challenge can be found HERE. Determine the items of clothing that have the highest average rating. In your analysis, include 1) only items of clothing that have at least 10 positive feedback reviews and 2) the five highest rated clothing items from each class. The original data and its metadata…
We hope you enjoyed last week's challenge. The solution has been posted here. For the second challenge lets look at removing characters and splitting data into columns based on delimiters. Many products will export textual data with delimiters such as quotes. This is done so that strings can contain delimiters or control…
Hi all, I am trying to build a workflow that parses XMLs (e-invoices, PeppolBIS) whereby all fields are extracted to an Excel, with the respective fields als a columnheaders and the value/text of the field in the row below. Ideally it would be set up in a way that we can do a batch input from a folder with numerous similar…
Here at Alteryx we know the importance of growing our experience at solving data and business problems. Almost weekly (~40+ times a year) we share an Alteryx challenge with our internal Alteryx users and then we all develop our own solutions. Later we review our solutions in small groups. Since many Alteryx users have…
The link to the solution for last challenge #38 is HERE. This week is a little different, as we work with Alteryx workflows and macros that were created by other people it may be necessary to ‘de bug’ someone else work or make modifications to get components to function in your workflow. In this case you will start with a…
Last week's solution has been posted HERE. A university analyst has been asked to help with course and classroom resource planning. The university sends course times in military time format. The university analyst wants the fields Military Begin Time and Military End Time to display in standard, 12-hour increments. So, if…
I'm currently building a macro that uses 3 different calculations with different columns based on the type of the file. Type 1: Columns A, B,C Type 2: Columns D, E, F Type 3: Columns X,Y,Z The user may not input all 3 different types which is causing an issue with the formula tool because it doesn't recognize the variable.…
The link to last week’s exercise (exercise #45) is HERE I love to share real world use cases as exercises. This week’s exercise comes from a customer that had data coming from in a legacy system and needed to transform the date field for a new system. It is a straightforward exercise but shows how easily Alteryx can apply…
Here is the new weekly challenge. The link to the solution for last challenge is HERE. For this challenge let’s look at ranking records when multiple records can have the same rank. The objective is to determine the top 5 ranking based on the count, however since there are multiple rows with same count (similar to a round…
It looks like you're new here. Sign in or register to get started.
