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.
Hello Alteryx, I would like to ask assistance of a simle workflow where the two input files will match if a keyword is found in the other file (1 or more words). Please see attached sample file. Thank you.
Hi Alteryx Community, I have a problem with my Fuzzy Match Tool. I'm matching vendor names from one dataset (checking potential duplicates) but the results are different depending on the sorting I add before the tool. I understand that the order would be different but I assume the number of matches should always be the…
Hi Alteryx Community, I hope you can help me with a workflow I’m trying to build in Alteryx Designer (version 2024.2). I have two input datasets: Input 1Contains a free‑text field (DESC1 OR DESC2) with embedded vendor names. Example (see attached dummy file - input 1 tab) Input 2Contains clean vendor names (see Input 2…
Hello, Could you, please help me? I want to check the AR_ Name column in the Client column and keep the common matching text (50-60% matching ). Moreover, if inside the AR_ Name clients have a similar name and if they do not match at all with the Client column, should return the AR_ Name. This should be applicable only for…
I have two Excel sheets: Sheet 1 (Master Sheet):This contains the full list of users, along with details such as their roles and statuses.Sheet 2 (Target Sheet):This contains a smaller, selected list of users, and it also has columns for roles and statuses.I want to:Identify users who appear in both the Master Sheet and…
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…
Hello - I am having an issue with Fuzzy Match. I have a data source that looks like: NAMEADDRESSNUMBERAMBERFLORENCE123 EXAMPLE1234TOM BRADY456 EXAMPLE4567MIKE TROUT789 EXAMPLE7890 And I have a list of Names that I want to Fuzzy Match for in NAME. For Example, my text looks like NameT BradyFlorence I have the second table…
Hello, I am having an issue with making an equivalent to the VLOOKUP approximate match in Alteryx. Formula example: =VLOOKUP(B2,Calendar!A:C,3,TRUE) B2 = Assigned Date = 8/14/2025 I need it to join the tables together so that I can return the check date of 8/29/2025 dynamically. BeginsEndsCheck DateWK…
Hello, Could you, please help me with the situation below: How can I, extract the invoice number, which starts with S0 and keep only the invoice number - Ex. S0001 00008761. I should mention that i can find more invoice numbers, into a line and sometime the invoice number might not respect all the number length.…
Dear Team, I want to add two column's in the given data. > Match % - It will reflect the % of name matching between two columns ( RESPONSE_FULL_NAME / PT_PARTNER_DESC ) > If % is matching above 75 % then = Yes / No Thanks in advance
It looks like you're new here. Sign in or register to get started.
