Hi, I have this dataset as attached. I would like to split the dates and text into 2 different columns. For example, for record #2, I want to convert from this: Description 11/07ADPGROSS-TO-NET to this: Date Description 11/07 ADPGROSS-TO-NET May I know how to go about doing this? Note that I have fields that do not contain dates and thus would like to keep them as they are and only split those fields with dates. Thank you! Regards, Hong En
... View more
Hello, I have a data file for an upload and some of the entities have multiple entries with the same date. For the purposes of the data load I need to edit the duplicate dates to a day prior. For example, if I have an entity with two entries on 06/30/2023 I need to update one of the dates to 06/29/2023. Is there an easy way to set up this functionality within Alteryx? Sincerely, Jacob
... View more
Hi, I'm unable to write the output to multiple worksheets of the same excel file. I've used an analytical app to filter the data by year and I'm also using the block until done tool so that only one workflow is getting executed at a time. Can't seem to understand why the output isn't being displayed.
... View more
Hello, I looked through the discussions to find my answer and what looked like it worked for other people is not working for me. I am trying to filter out multiple account IDs using one custom filter tool and the OR operator, but when I run the workflow it does not filter anything out. It also does not throw an error when running so I am not sure where exactly my issue is. Code for filter is below: [Account ID] !=10681 OR 10781 OR 10662 OR 10782 OR 10801 OR 10657 OR 10562 OR 10554 OR 10687 OR 10688 OR 10700 OR 10737 I have tried to wrap the formula in parens but that did not change the outcome. My workaround which I have been using thus far is to add a new filter tool with each additional account ID as they come in. This has worked for me, but the list of IDs to filter out is growing and I don't want to have 50+ filter tools in a row for each ID. I'm sure it is something simple I am missing so thank you in advance for any help!
... View more
The configuration panel of download tool is broken; the connection setting part shrinks, and I cannot see it. How can I fix it? GUI Alteryx Admin Designer Version: 2023.1.1.247 Patch: 2 Engine Version: 2023.1.1.123 Windows 10 Enterprise (Version 20H2)
... View more