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.
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, I have data with countries in clusters, if country is matching it is duplicate, if not matching Not duplicate. If Country is blank for any of the records in the cluster, if should check for City. Same logic applies to city. Please find the table below Record IDCluster IDCountryCityStateConclusionABCAUNITED STATESUNITED…
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 would like this process to change the Year to what the user inputs (2026 to 2025). I can't figure out how to do it.
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…
I am trying to read in some iqmsg files in Alteryx to do some analysis on these log files, however Alteryx does not seem to support this format. The files are big, and I wonder if it's possible to read in a iqmsg file in Alteryx.
Hi there :) I have a batch macro that opens multiple Excel files since the schema changes. However, at times there will be a file that is corrupted and the macro doesn't work. I found online a Python script that would identify the files whose Error Message says "File is Not a Zip File". I was planning on filtering those…
I have excel which contains multiple sheets, each sheet can contain multiple tables. There is no defined boundaries for tables. Subsequent files may have tables with different columns at different places. I am not looking for a solution that is static (file to file). I am looking for something which can identify the…
I have a flow that extracts data from SP. When there is data, there is no issue, but when there is no data, it cannot produce a table. How can I trick Alteryx to do so? Note: I cannot add a dummy row in SP.
Hi, I'm in IT and I have a user having issues with Alteryx. I've copied/pasted what he wrote on the ticket. I am trying to see if there is a contact or if someone is able to guide me on how I can resolve an Alteryx error. Typically, I just drop a new file every quarter into the input folder and should be able to run…
It looks like you're new here. Sign in or register to get started.
