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.
Hi Everyone, I’ve compiled a set of best practices I use to clean messy tabular flat‑file data, most often from CSVs or PDF‑to‑Excel exports for general ledger, payroll, sales, and similar reports. These requests usually involve applying the same cleanup steps across many files or sheets and combining them into a single…
Super cool, this new tool! There are many differences compared to the older version: It can remove invisible characters. It can remove letters, except for those in a specified list (e.g., A, Y, X). It can remove numbers, except for those in a specified list (e.g., 1, 2, 3). It can remove punctuation and special characters,…
For many times, you want Alteryx to process some data, generate a report, and send to a group of recipients. However, you cannot really trust Alteryx to send directly to recipients because you want to check the report for the last time before it gets dispatched. If Alteryx is going to just generate the report and send to…
Hi All, I'm looking to generate a list of workflow in each collection level. How to generate and what is the process to create a workflow?
I have a schedule I need to transpose with a lot of data. Any tips, tried transpose but was unsuccessful.
I downloaded Alteryx Design. To activate the license, I am required to sign in Alteryx One. I put the email I use to sign in Alteryx Portal, but no code is sent to me. I checked the spam, and I did it 2 days ago. I'm using free license from school email. Please help me. I can not find any videos, instructions.
Hello and good day, I would like your assistance in retrieving the "Y" flag from the lookup table. I have attached example files: a dummy file and a lookup table. The "Short Name" in the dummy file should be matched against the lookup table. When a match is found, the corresponding value ("Y" or "0") should be supplied to…
I have 300 Records for 12 months of data, that is 25 rows per month Group By Month and value in Descending order. I want to put a record Id for all the records, for example for the 25 records in Jan i want to keep the record ID as 1 to 25 and it has to be the same 1 to 25 for all the other months for total 300 records. how…
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…
It looks like you're new here. Sign in or register to get started.
