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 there. Im a newbie into the macro world. My purpose is to output from each excels files and sheet an output with columns empty etc and the adress like L1C1 you know. From a tool DIR im taking my .xlsx files and output directly Full Path. Then im connecting into a macro for listing all the excel sheets and get a column…
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'm looking to generate a list of workflow in each collection level. How to generate and what is the process to create a workflow?
Hi All. I am trying to display a custom message on the Alteryx server after a certain condition is met. Using Message tool is helpful on the Designer but it does not work on the Server. I have tried using the Output Message option available at the Interface Designer Setting Option but it is not of much help as my message…
Is there a way (i thought it would be though dynamic rename, but not sure if this is the right way now) of how you can take the data from the first row of data, and add it into the column heading? So in the images, I want the first row of plant, to be added onto OpenSO Qty Balance as per the second shot. To add context, I…
I asked a question yesterday to learn how to split a datafile by AccountLead, the response I receive works well, thank you! However, I would like my output files to have formatted column headings with colors. I have tried a few different options, including using a template for my output but the issue when I do that is that…
I have a large data set of ranges of a transport network. I would like to find duplicates on the Start Miles/yards and End Miles/yards. This is easy enough with a unique tool. However, I also want to find duplicate entries that fit inside the widest range, for example. Start mile 29 start yard 770 end mile 29 end yard 109,…
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 All, I need a formula to derive previous business date from current date. Can anyone assist. Example - Input Today's date - 08/21/2023 Output - Previous business date - 08/18/2023
It looks like you're new here. Sign in or register to get started.
