ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions.
Learn more here
Using Alteryx Server 2025.1.2.165 Patch: 3 and installed Salesforce Input Tool versions 5.1.3 and 5.1.4. When synching the connection in DCM the gallery shows the following error: This Data Source was created using a schema ayx.api-salesforce that’s not currently present on your system. Checked that Tool is installed in ProgramData\Alteryx\Tools as admin (vs user). Connection works locally on server machine's Designer. Looking for solutions to ensure the connection is usable in Server.
... View more
Euleryx Problem 20 – Factorial Digit Sum
My workflow and macro:
Workflow:
Macro:
Answer: 648
Last Week's Favourite Solution:
The favourite solution award for problem 19 has to go to @DaisukeTsuchiya. With two solutions, one utilising Alteryx’s built-in functions and the other solving the problem using basic numeric values alone, this solution is well worth a look. Please find their solutions on page one of last week's post or click here.
Mathematical Theory:
This problem is in many ways similar to Project 16, as we have to multiply large numbers together. As we already know, computers struggle to do direct mathematical calculations of larger numbers. A way to get around this is to break the numbers into their single-digit components.
Lets take a small number (99) as an example:
We already know that 2 x 99 is equal to 198. But do we actually calculate this? A common trick taught in school is to multiply the digits separately, and then add all the answers together. I.e do 9 x 2 and then 90 x 2 as two separate calculations.
This same principle works with larger numbers. As the computer cannot handle large numbers by itself, we will just break them up into separate digits.
Method:
1) The first step is to simply create your starting value. I decided to perform the multiplication by increasing the value each time, i.e 1 x 2 x 3 x …. x 100, hence the input value is 1.
2) Next, we enter the iterative macro (for illustrative purposes, I have the number 99 flowing through the macro). Inside the iterative macro, the first steps, is to add some placeholder rows.
The placeholder rows should appear at the bottom. Writing this number out normally, we should get 0099, which is just 99. The purpose of the placeholders will become clear shortly.
3) Now we perform the multiplication based on the engine iteration number. In this case we are simulating the first iteration so the value 99 with be multiplied by 2.
You will notice that the “New number” column, looks a little different. The value in this column is formatted so you have the units_non-units. - So for the first row, 9 x 2 is 18, it’s the first row, hence we don’t need to worry about anything else. We then write the answer 18, in the units_non-units form to get 8_1
For the second row. 9 x 2 is also 18, but on the previous row, there is also a 1, in the “non-units” section, so we have to add this onto our calculation: 18 + 1 = 19. Expressing this in the same form, we get 9_1
The third row is actually one of the placeholders, hence the multiplication 0 x 2 = 0. But again, as we have a 1 in the non-units above, we need to add that value on, to get 1_0.
The final row is just 0
4) Now we can simply take the units values, and paste them into the original “input” column.
Reading the value out, we would get 0198 = 198. We can then also drop the “New Number” column.
5) The final step within the macro is to decide whether to loop again or not. This is determined by a filter on the engine iteration number, powered by a numeric up-down, on the macro interface. For the purpose of this problem, it has been set to 100.
6) Once the macro has ran, the value of 100! will be expressed in a single column, each cell containing a single digit only.
To express the number ordinarily, you could reverse the order then concatenate the values; however, as this column format displays all the digits individually, to answer this problem, we can simply sum the column to get to the answer.
7) Submit your answer to the Project Euler Website!
Summary:
Another problem to test how well we handle large numbers, but like before, we were able to arrive at an answer by isolating the digits, converting the large number calculations into lots of small multiplications and additions.
Want to find out more, follow this link to our introduction post - Euleryx: Let The Games Begin.
... View more
Hi all, I have an Excel file with forecast columns Jan_2025_LC, Feb_2025_LC, Mar_2025_LC, ... and corresponding actuals: Actual_Jan_2025_LC, Actual_Feb_2025_LC, Actual_Mar_2025_LC, etc.(Sample data attached) (This pattern repeats for each year, e.g., 2025, 2026, etc.) I want to build an Alteryx workflow where, if I select a run period (for example, Mar-25), the workflow will automatically replace the values in Jan_2025_LC, Feb_2025_LC, and Mar_2025_LC with the values from Actual_Jan_2025_LC, Actual_Feb_2025_LC, and Actual_Mar_2025_LC. For months after the run period, the forecast values should remain unchanged. I also want this logic to work dynamically for any year (2025, 2026, etc.), not just for 2025. What’s the best way to set this up in Alteryx Designer? Any tips, sample workflows would be greatly appreciated!
... View more
i'm creating a workflow that (1st control container) checks to see if a dir exists, if it doesn't it will create it, then (2nd control container) move .csv files from path A to this newly created/existing path. they work when run separately but don't when combined. want to see if adding a delay between the 2 containers would help.
... View more