I am trying to connect the FlightAware API to Alteryx, but can't seem to get the API Key to authenticate in the Download tool. Their website says that "Unlike previous versions of AeroAPI, authentication is now controlled by an API key that must be set in the header x-apikey". Is there a way to do this in Alteryx?
... View more
Hi everyone, I'm working on a dataset in Alteryx where the vwstring field contains values in the format 999999999999999.99. The requirements for validation are as follows: 1. The value must have exactly two digits after the decimal 2. The number before the decimal can be up to 15 digits (leading zeros are allowed in the case where the number is less than +/-1. 3. A negative sign is allowed but optional. 4. Valid examples include point 0.15, 123.45, 0.00, 999999999999999.99, and -123.45. I created the following REGEX_Match formula to validate the field: REGEX_Match([FieldName],"^-?((0|[1-9]\d[{0-14})\.\d{2})$") this works fine for most cases, but when the value is 0.00 the vwstring field seems to automatically convert to zero (0) when it enters the formula tool..As a result, REGEX_Match fails because it is trying to match 0.00 but encounters just zero (0). My questions are: 1. Why is the vwstring field being interpreted as 0 instead of 0.00 in the formula tool? I changed the type to string and I got the same result. 2.How can I adjust my formula or workflow to ensure that 0 .00 is correctly validated? Any insights or suggestions will be a greatly appreciated. Thanks in advance!
... View more
Hi Alteryx Community, Do any users have experience using the new control container functionality in combination with the Python tool? Or know if the two can work together? I'd built a test case with control containers and got that working as expected (with very basic tools inside). However, when I transitioned to my actual use case that involves using the python tool inside the control container, the python tool would try to run even though the control container was not activated. Appreciate any feedback on this. Thanks
... View more
