My workflow is scheduled to run weekly with an updated excel. Currently, the recipients(3) are based on a column (i.e.USER_EMAIL) that has email addresses listed. This recipient list can vary depending on the week. My issue is that when I'm testing with my email as the recipient(To: MYEMAIL@EMAIL.COM), I get 3 separate emails when I should only get 1. How do I make sure that the recipients only receive one email? Also, everyone listed actually gets an email? Thanks in advance!
... View more
I have a list of ReviewDates and holidays/non-working days for 2025/2026. I need to return two different dates, which should be calculated as follows: PrepDate1 = ReviewDate - 2 working days PrepDate2 = PrepDate1 + 1 working day The PrepDate1 needs to be exactly two workdays before the review date, so if the ReviewDate is 5/27/2025, then PrepDate1 would be 5/22/2025, since it would not count Memorial Day, Saturday, and Sunday as workdays. PrepDate2 would then be 5/23/2025. If there was a holiday or weekend between PrepDate1 and PrepDate2, then it would skip over those dates and land on the next working day for PrepDay2. I saw some similar community solutions when searching, but I had difficulty modifying them to fit my requirements exactly. I also saw that apparently there is some Alteryx function called Networkdays which allows for a holiday input, but I couldn't figure out how to add this function to my version of Alteryx. See attached for the excel docs of ReviewDates and holidays. Thank you in advance for any guidance you can provide!
... View more
Hi I'm working on project where I've created a Power BI dashboard to check on stock data it gives various insights in candle graphs and fall and rise of stock. I was just using yahoo finance API to get data thus I'm now thinking of automating the process of data collection such that real time data is collected and i get realtime analytics on PowerBI rather than generated data csv as an input. Thus I require help how should i proceed with all this
... View more
I have upgraded our Alteryx Server in Sandbox environment from 2023.1 to 2025.1. Before the upgrade: Stopped Alteryx Service in the Worker server. Stopped Alteryx Service in the Controller server. Stopped MongoDB service in the user-managed 3 MongoDB servers (replica set). Upgrade: Upgraded Controller Server. Upgraded Worker Server. After the upgrade: Manually started MongoDB service in the user-managed 3 MongoDB servers (replica set). Manually started Alteryx Service in the Controller server - FAILED. Manually started Alteryx Service in the Worker server - FAILED. Navigated through the System Settings in the Controller server - COMPLETED. Navigated through the System Settings in the Worker server - FAILED. Encountered again the error "Alteryx Service and Client are incompatible" on the Remote Controller settings. ALTERYX SERVICE LOG 2025-05-22 11:05:04.551000,ERROR,1448,AlteryxService,,,,,,,,,"S:\Alteryx\Service\AlteryxService_Client\src\RunAlteryxServerMigrator.cpp: 138. Server Migrator failed with exit code <3762504530>. See Migrator Logs for detailed error message. This error must be addressed in order for the service to start." 2025-05-22 11:05:04.806000,INFO,1448,AlteryxService,,,,,,,,,"ServicePoolController_Shutdown_Stop: Stopping plugin " 2025-05-22 11:05:04.806000,INFO,1448,AlteryxService,,,,,,,,,"ServicePoolController_Shutdown_Stop: Stopping plugin " 2025-05-22 11:05:04.806000,INFO,1448,AlteryxService,,,,,,,,,"ServicePoolController_Shutdown_Stop: Stopping plugin " 2025-05-22 11:05:04.806000,ERROR,1448,AlteryxService,,,,,,,,,"AlteryxService_SvcReportEvent: App message . See Migrator Logs for detailed error message. This error must be addressed in order for the service to start.>" 2025-05-22 11:05:04.806000,ERROR,1448,AlteryxService,,,,,,,,,"AlteryxService_LogStartupError: There was an error starting the Alteryx Service . See Migrator Logs for detailed error message. This error must be addressed in order for the service to start.>" alteryx-service-migration.csv Date,LogLevel,ThreadId,ProcessName,LoggerName,Location,Message,Exception 2025-05-22 11:05:01.810582,INFO,1,AlteryxServerMigrator,migrationLogger,UseParsedArguments,Alteryx Server Migrator is initialized., 2025-05-22 11:05:01.841832,INFO,1,AlteryxServerMigrator,migrationLogger,UseParsedArguments,Server Mongo Database migrations will not be run via ServerMigrator., 2025-05-22 11:05:01.841832,INFO,1,AlteryxServerMigrator,migrationLogger,UseParsedArguments,Server SQL Db Migrations are not run as no connection string was provided., 2025-05-22 11:05:01.873091,INFO,1,AlteryxServerMigrator,migrationLogger,UseParsedArguments,Beginning Service Mongo Db Migrations, 2025-05-22 11:05:02.972236,FATAL,1,AlteryxServerMigrator,migrationLogger,VerifyDatabaseVersion,Database version 45 is newer than the code version 7., Same issues were encountered when I tried to upgrade from 2023.1 to 2024.1. I just performed rollback and decided to upgrade directly to 2025.1.
... View more
Hi Team, I am working on a workflow which is sending email at the end. In email text some special characters are not coming properly. E.g. the text "Nestlé Nutrição Infantil" is coming as "Nestl� Nutri��o Infantil" in the email body. However the data is preserved properly in the attachment. Please advise how to fix this issue so that the data is preserved in the email body as per the attachment. Thank you. Regards, Amol Patange
... View more