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 all, I have column with "date" date type field and the values there are for instance "DEC-20", "NOV-20". I would like to change this column to the number of the month, e.g. "12", "11", ... . Anyone has a simple solution to do so? Alternatively, it it's easier to convert to the month number from the string, please say…
I am trying to calculate the number of days that happen in each year when the range crosses a year boundary. Examples are handover_datetimereturn_datetime12/3/2022 11:301/21/2023 18:5812/5/2022 14:001/5/2023 14:0012/26/2022 8:3012/31/2022 17:5512/15/2022 13:301/16/2023 8:4612/10/2022 13:411/23/2023 12:00 I have been trying…
I wrote an If Else statement in a formula tool to capture the months that are less than or equal to the "End of Month" date based on today's date. The issue is that it should also be capturing row 4 as the End of Month is 2026-04-26 (so less than today's date 2026-04-01). However it is not, and the Range column is stated…
I am trying to take a list of dates in a text input tool and compare them to the current date using the test tool. If the current date matches a date in the text input tool, then the test should pass but if not then fail. Apparently the test tool does not work that way. If there is a non-match then it fails whether there…
Hi, I hope someone can help as I have searched the community and none of the solutions provided appears to work. I have a string field of the format below 2026-03-11 12:00RACEDAY What Im trying to do is search for date using filter and true/false. This will filter out all fields with this format, then I need to parse date…
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…
Once the output is generated from alteryx, i would like to know if any logics are available in alteryx formula to reflect the current date whenever the documents are opened. For example - if the document output is genreated today, if the files are opened tomorrow- it should reflect tommorw dates on the respective field or…
I am using the following formula to pull the last 6 months of data starting from the prior month backwards. Essentially I want a rolling 6 months. For some reason though its including data from the first day of this month and does not include data from the first day of July. The data starts on 7/2/2025 and goes through…
Hey, I have attached same excel. My requirement is I want data to be copied from "MTI Cumulative Current" to new column "MTI Cumulative Current Previous" when I run this next month/ quarter Say, currently value in "MTI Cumulative Current" is "181892.4" so when I run this next month "MTI Cumulative Current" will have some…
It looks like you're new here. Sign in or register to get started.
