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…
Good evening everyone. Was hoping i could get ideas, or maybe steer me in the right direction, on how to build the below (see screenshot). I have a numeric field called AMOUNT and i need to be able to create a new field that spells out whatever is in the AMOUNT field. Is there a tool that will do that? Asked Chatgpt and it…
Hi All, I am one of many users on data teams who use Alteryx at my company. The team I am on consists of five users, down from six. We have fifty-plus workflows published and running in our team collection. The user we recently lost published many of our workflows. Now we have to manage updates to them all. To do this I've…
I have an input tool connection to a third party SQL database. It contains roughly 100 tables with various fields unique to each. I'm trying to connect to the database then create a list of the table names and fields to generate a sort of data dictionary. The third party adds tables and fields regularly, so I need it to be…
I have a schedule I need to transpose with a lot of data. Any tips, tried transpose but was unsuccessful.
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…
I have a workflow which is working on my local desktop and server seamlessly. When I downloaded from my server for a enhancement, and when trying to re-upload, it's giving error. 'No incoming metadata from one or more upstream tools. Check the input data and run the workflow again' My both inputs ( 1 is .yxdb and other is…
Upgrading your Alteryx Server environment often means performing a sequence of delicate steps—one misconfiguration, missed backup, or delayed manual hand-off can derail the entire process. That’s why our team developed a new automated script to automate the Server host recovery process that may be required during an…
* No Data Cleansing tool* Too slow and risk of configuration loss * Use instead Multi Fields Formula Tool * Left join connected to main data stream and enrichment/filter/correction/Comparison on the right* For easier reading of the workflow * Select after Input Data tool and before Output Data tool...* If you don’t want to…
It looks like you're new here. Sign in or register to get started.
