Hi guys, Is there a way I could get the date in the email below using Alteryx automation or other means aside from copying and pasting it using the report text tool in Alteryx? I'd like to get or extract "Wed 5/8/2024 6:29 PM" and convert/format it to "Wednesday, May 08, 2024 6:29 PM". I'd like also to extract "20240508 06:28:41" exactly as it is. Anyone please. Please help. Kamen
... View more
Hi all: I'd like to prepare output from the input table below. I can do this using summarize tool. But there may be additional column(s) appear in future. How can I summarize those additional columns as the summarize tool doesn't have dynamic or unknown column features. Is there any alternate way? Input Output Thanks
... View more
Hi all, We have just installed the latest update, it seems to have removed saved connections from the input tool, was this planned or a bug? Whats the best way now to set up common database connections so that anyone in the team can run the workflow? Edit, we have tried to set up new connections under File - Manage Connections but my colleagues get "Invalid connection" if they open a workflow I create even though they are using the same DSN and connection name.
... View more
Hi, Is it possible to schedule an Alteryx workflow without using Alteryx schedular like calling Alteryx workflow via api or python code or any other means.
... View more
Hello, I'm doing a simple calculation to change the sign of incoming value to the opposite sign. While doing so, my first mathematical approach was to simply multiply it by (-1). What I have noticed is, while all the numbers are getting with opposite signs, 0 is also getting assigned with negative sign. You may see 0 in output window but in detailed window it shows as -0. More over, even when I tried to transpose the column it is showing as -0. I tried the same thing with incoming null values to get converted to 0 first and then to apply formula, go the same result. I'm using Version: 2022.1.1.30961. Is this a known issue ? Sample data I used - Value ID 1 A 10 C 100 B 200 E D 0 G -300 H
... View more