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.
I can't quite get my head around the Multi-Row formula tool for my data. I'm trying to keep only one of two rows of data per employee per range of dates. The image below shows the input data with the values I want to keep highlighted yellow. Attaching data that has a tab for the desired output as well.
Hi Community - In the sample excel, I have a few lines of the same invoice. I want to summarise it together into a single line with the Tax Rate as SGST and CGST coming under two columns. I tried using summarise and cross tab, but it is coming into two lines instead of one. Can someone please help?
I used to use a combination of the table tool and cross tab tools to create 2 lines of headers in my reporting tools. It worked up until 2024.2 Patch 7? I submitted a ticket with Alteryx and they told me it was fixed in 2025.1. We've finally been able to upgrade and it's still not fixed. While I wait for Alteryx to figure…
Hi Team, I am able to achieve the following output in Excel using conditional lookup refer to Calcs tab, and I want to achieve the same in Alteryx
Hello, team I need your help to figure out an easier way to split the data from 1 row to several rows. I have an Excel file that shows the drug that was shipped to clinical sites. However, some rows have multiple site numbers in the same row. I attached an example. I need to split the site numbers in different rows. For…
Hi I have the data as attached for 5 year. I need to calculate Each month average. for example for Jan 2025 - The average should calculated by Dec'24+Jan'25/2 and for Feb'25 it should be Jan'25+Feb'25/2 and for all the years data it should calculate in this way How to Acheive this through Alteryx? Can someone help me out…
Hello Professionals, I'd want to thank all professionals who helped me when I was stuck while studying for Alteryx Designer Core. I'm unsure if the next step is Alteryx Designer Advanced, but I'd like to continue learning more about Alteryx. Any advice and instructions on what sources to learn and practice is very much…
Dear all, I have several excel formulas that I want to translate to Alteryx. I tried to adopt Multi-row formula to update the row, however, the dependency between each field would cause difference answer after I reapply the formula. e.g. DATE UNIT_POSITIVE UNIT_NEGATIVE MKT PRICE Unit c/f Avg price Amount c/f 12/15/2025 -…
Hello - thanks for the help in advance. I have cells that follow this format: qual RES1 'Restaurant' = 'Five Guys/Burger {US}' qual GY1 'Gym' = 'Planet Fitness' qual LOC1 'Location' = 'New York/{Bronx, Brooklyn}' concept 'Example 1' where 'School' = 'Syracuse University' and RES1 and 'Meal Type' = 'Dinner' concept 'Example…
Hello everyone, I hope you are doing well ! I have a really important question, Is there any way to do this in Alteryx ? Thank you in advance.
It looks like you're new here. Sign in or register to get started.
