Participate

When rendering to excel I get 'number formatted as text' errors for some negative numbers see below:     The -92,477 is not detected as an error but the other numbers are.   When I look in the Excel cell for the -92,477 i see -92476.8   When I look in the Excel cell for the -92,846 i see -92,846   Notice how the cell that errors out contains a comma and is rounded, this is the same for the other numbers resulting in number as text errors.   Further info, I had thought rounding was the issue, prior to this the numbers had up to 8 decimal places, and when that was the case only the -100,279 was erroring.    I added 0.01 rounding to the formulas that produce these values and now even more (but not all) negative numbers are erroring this way.   Any ideas?      ... View more

Hey all,   I along with many others have added a daily game of Wordle to my morning routine. Inspired by the BaseA challenge for the Advent of Code and exploring the art of what is possible within Alteryx I journeyed down the path of building the game of Wordle in Alteryx. It ended up being an interesting use of chained apps and some of the reporting tools.   For those who don't know Wordle is a basic word puzzle game with a cool backstory.  The basic premise is you need to guess a "random" 5 letter word within 6 guesses. Each day a new word is available for you to try to guess. Everytime you guess you get the following information: The letter in the position you guessed will be highlighted green if that letter is in the target word in the correct position and location The letter in the position you guessed will be highlighted yellow if that letter is in the target word but a different position The letter in the position you guessed will be highlighted grey if that letter isn't in the target word Example from 1/14/2022 (Warning spoiler of the answer)   This seemed like an interesting challenge for Alteryx. So I set upon my journey to build Wordle in Alteryx.   Getting the Word List The first step in rebuilding Wordle was to get the list of words that are approved and that will be tested. Spoiler for major Wordle fans below Inside the Wordle website code (inspect element) is a link to the underlying dictionary to the game. The dictionary is also the order in which the words appear daily. You can do your own sleuthing to find the list if you want inside the HTML. Once we have the dictionary we have to apply the date to the list that way the Alteryx version and the website will display the same word when you're playing the game (I'm sure there are some time zone games that can be played so the words won't align, but I'm not dealing with time zones for a fun project).    So now we have a dictionary of words that can be entered by the user as a guess and the target word that the user is guessing that will change daily.   User Input The first part of the build was designing the user input. Simple enough allow only 5 letter words on the dictionary list. Should be a simple task but as anyone who knows UX design will tell you users love to do everything except what you want. So how I reigned my users in: Allowing only 5 letter words Using the Error Message tool I leaned on some Regex to test that the user was truly inputting a 5 letter word. No sneaky special characters or numbers length(regex_replace([#1],"[^a-Z]",""))!=5 Words only from the dictionary I tried to use the error message tool, but it turns out Alteryx is not a fan of having an IN statement with 8,000+ words Simple enough just run the selected word against the dictionary using a join. If the words not on the list throw an error Logic Gates The logic was pretty simple. Parse the word into it's letter components. Join the input word against the target word and apply a formula: IF [Input Value] = [Test Value] THEN 2 ELSEIF contains([Test],[Input Value]) THEN 1 ELSE 0 ENDIF   Reporting I kept it very basic and built out 2 reports: Guess Report This report tracks your guess and does the background coloring based on what you guesses It keeps a log of previous guesses for you information Congratulations Screen If you get the word you'll also have a congratulations screen appear.  Making the game To make the game you just need to repeat the above steps. The only change is creating a log to keep track of guesses and updating the reporting so it can handle multiple rounds of data.   I've attached the packaged chained apps. I'm sure there are a few ways to approach this and ways to clean up and optimize. Would love to hear others thoughts!     ... View more

Hi We just now did renewal for Alteryx designer and server licenses. However after that new licenses are not showing on Alteryx license portal .Any workaround or solution will be helpful. ... View more

Hi, I'm using shared folder to read the files from Input tool and Output tool to create the excel files. My workflow generates no. of files based on a category. I'm facing 2 issues with this, 1. Output tool is taking more time to create files in the shared folder where in local machine it is not 2. When I'm publishing the workflow it is giving below error.   There is no security and I have all the privileges' on the shared folder.   Please help me with this.   Thanks, Riaz ... View more

I have a gsheet input with a mix of negatives in parenthesis and using minus sign.     I put this field through a Select tool and change the data type to double, but the 2.50 and 2 turn to NULL.   Best way around this so the negatives are recognized?   ... View more