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, I have a workflow that starts with a Directory tool and then connects to a batch macro that is working to combine all files in the directory into one data set. For each iteration of the macro, I want the macro to list the file name for each record where the record came from. How do I do this? In the screenshots…
In Designer 2025.2 I exploring the possible to use macro for Input tool (Sharepoint connector v3). that try to: different file different folder different library different site my current finding is to replace the whole LocationInfo and ParentLocation xml structure. (still in try and error mode) in v2.7, i can just change…
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?
I have a data file with forecast information by account. Each account have an account lead and each account lead have multiple account. From the file, I want to split the data by account lead in separate files. Is it possible to build a workflow that will create multiple files?
Dear Team, I am trying to extract data from some large tables and i am looking a way to create a Batch macro input that uses variable year and month data in extracting the data. Year format is "YYYY" while month is formatted as "MM". Year Structure: NameSelectionOperatorLowKeyHighKeySplitRYEARIEQ2024 True Month Structure:…
Hi, I am trying to create a batch macro, where I have a main folder "customer" > it has different subfolders of unique names ? inside that it has latest files associated to that subfolders. I want to iterate over each of the subfolder and fetch the latest file. I have tried creating a macro for that but its not working or…
Hello There , Im a newbie in Alteryx Designer and i have to build a macro ( batch) to read my Excel file. The idea is from a workflow : Excel File -> Full Path -> (Macro w control parameter to get the FullPath) -> Output : FileName SheetName RowNumber ColumnNumber Name (Column name) Value ( inside my row) IsColumnEmpty…
Hello, I've created a workflow that compiles a month's daily files into a monthly snapshot. The files all come from one location and follow the same structure (all the fields are the same) but when I tried to use an input tool, after the first file is read, all the remaining files in the folder are skipped over as they…
Hello, i need to create a batch macro for this input file to get all data from all these sheets. i mean on my mail workflow i will have text input tool with list of necessary sheets name then connect that text input tool to batch macro so then i will have data only from those sheets listed on my text input. i build a macro…
I have a google sheets workbook that has 2 tabs: Data and Pivot Table. The Pivot Table tab uses the data from the Data tab. Currently Alteryx is using the Google Drive tool to overwrite the Data tab daily. Now I have to duplicate the google workbook, append the date to the workbook file name, and write to the Data sheet. I…
It looks like you're new here. Sign in or register to get started.
