ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions.
Learn more here
I have uploaded 1 file Hierarchy_Template which is Input file in this. 1st we have to put filter on Type = Profit center Then we have the data which will pick ID. Afterwards we need to pick "ID" column value say "74226" then we will pick it's Parent ID "43420" this will be hierarchy 1 and then we will search 43420 in "ID" column again and pick parent ID "43388" this will be hierarchy 2 again we will search "43388 in "ID" column and pick parent ID till we get P001 which searching till P001 we will remove filter of Profit Center and then it will pick next "ID" after putting filter of Profit center Is this possible in Alteryx? Can someone help me creating this workflow?
... View more
I have cleared micro- credentials foundation course. But haven't received Designer Core Certification badge mail from Credly and it's been more than 48 hours now. Please help
... View more
I am looking to random sample using multiple fields. for example: I need 30% of sample using Approved by but the output should have equal proportions of Assignee. I tried using the sample tool but was not able to achieve the desired result. ID Assignee Approved by 1 Hema Manager1 2 Chan Manager1 3 Abdul Manager1 4 Kiara Manager2 5 Chan Manager2 6 Kiara Manager2 7 Kiara Manager1 8 Chan Manager1 9 Abdul Manager1 10 Kiara Manager1 11 Abdul Manager3 12 Kiara Manager3 13 Chan Manager1 14 Kiara Manager1 Output should be similar to what I have below. It has 30% sample of approved and also makes sure that it captured all assignees 1 Hema Manager1 2 Chan Manager1 4 Kiara Manager2 11 Abdul Manager3 14 Kiara Manager1
... View more
EDIT : Pretty much no vba/vbs macros are running on the sandbox, irrespective of workflow. No idea why this is happening, if i remove the macros the workflow runs fine. Excel files have some formulas that need to calculate/refresh post populating said file with alteryx, so I use some VBA code to open, save and close file to "refresh", so the formulas calculate. (VBA code is triggered by a vbs file that I link through a Run tool.) This whole thing works fine locally but in sandbox workflow gets stuck at that run tool infinitely. I tried opening the vba file manually and it opens fine, tried running the vbs script and and it gives no errors.. The file that's being refreshed also opens fine so no corrupted files or anything like that causing issues. Run tool Configuration: Command: wscript Command Arguments[Optional] path\to\file Working Directory [Optional] (empty) read results and write sources are some random empty template files Interestingly, I used to face this same issue locally and the fix was always opening task manager and manually ending background excel tasks. But how do I do this on a sandbox server? I feel like this is the issue because another different workflow that was working fine now has that exact same issue, although none of the alteryx workflow was modified since it was last working fine. All files on sharepoint and I've confirmed that Alteryx has access to that sharepoint
... View more