Hello! I am using REGEX_Match to try and return values that have numbers in it. I'm using the formula: "IF REGEX_Match([Field 1], ".*\d+.*")=-1 THEN [Field 1] ELSE Null() ENDIF". I want the formula to return values even if it has a letter in the field. For example (0124AC243). For some fields it is returning the values, but others that have letters at the end it isn't recognizing the numbers in it. Any suggestions? Example of cells that aren't returning: 00002418MXF Cells that are returning: R21751076
... View more
I'm running into issues trying to use control containers where I'm getting this error for seemingly no reason. I've tried replacing it with a new control container and I've tried disconnecting it from subsequent linked control containers all to no avail. The Error My version I'm not nesting control containers, which I've read on other posts could be an issue.
... View more
I am using the Google Drive Input connection to connect to a Google Sheet with multiple tabs. The setup of each tab is different so I have 6 separate connections for the Google Drive Input tool. When running the process I am getting the following error "Error code 429: Reached rate limit for requests." I assume it is because I am referencing the same file for each tab. Do I need to create 6 separate Google Sheets to reference instead? Or is there another way around this?
... View more
I'm trying to give formula in multiple fields based on the values present in multiple fields. Below snippet is an example of what I'm trying to achieve. I want to give formulas in fields(highlighted)
... View more
Hello: I have received a data file with an annoying layout. The layout looks like the following: Eastern Division Fort Hamilition Section Gate C-2 2021-05-21 Passengar Vehicle - Contractor 2 Truck - Military 3 Parris Island Section Gate G-4 2022-07-18 Passengar Vehicle - Contractor 3 Truck - Military 2 Motorcycle 4 Northern Division Fort Edward Section Gate Q-11 2023-09-07 Truck - Contractor 5 Bicycle 2 2023-09-08 Naval Sub - New London Section Western Division Fort Jackson section Fort Drum Section The division applies on till it changes. Same with the section, section applies until it changes. Not too bad for a human. How can I use Alteryx to clean this up? I need rows containing Division, Section, Gate, Date, vehicle, count Any ideas I am stumped? Thanks for your kind assistance Kevin Duffy
... View more
