My head hurts on this one! I am trying to calculate overtime based on 2 conditions. If your WcState (in Rates file) is equal to CA, you get Overtime over 8 hours a day (Marta Jones) (Sean Jones) AND overtime for hours over 40 as well (Sean Jones). if your WcState (in Rates file) is equal to anything else, you get overtime for hours over 40 a week. - (Katie Jones) Sean Jones is not working correctly. He should have 40 hours Regular (28 hours + 12 hours) at $80 VNDLY Pay Rate ST Hr AND (7 + 2 + 4 hours) at overtime rate $120 VNDLY Pay Rate ST Hr. I don't know how to calculate the hours over 40 he should get overtime for, they are going into the regular time calc.
... View more
Hi All, Thanks for your time, I have this dataset which iam exporting into .xlsx file into a sheet and this sheet has formula columns which are manually created within the excel and it looks like below Date Item Name Points Team Name Excel Formula Col1 Q1 240 Excel Formula Col2 Q2 241 Excel Formula Col3 Q3 242 3/31/2025 Q1 Farm Data 20 Team XYZ IF($A1<$B$2, IF($E1>0,($C1/$C$2)/$E1,0), 0) same sort of formula same sort of formula Question is: Using the overwrite sheet (Range) keep formatting option - i would like to write the data for the columns Date, Item Name, Points, Team Name with the data coming from say database or with the data that is cleaned and ready for use - within the alteryx itself. will the formulas work when we open the .xlsx file. Going through so many threads but not seen this without the issues... could someone please suggest any ideas or workarounds. Unfortunately the formulas has to stay to the right after those 4 columns because they are referring to the data points which is nothing but those 4 columns thank you so much for your time
... View more
We would like to be able to export all workflows on our server so we can then add the XML to a drive where we use a tool to look at the impact of changes in our systems. So workflow X accesses table Y and we are going to rename a column in Table Y, we want to be able to quickly find out that workflow X uses this. Ive used the server API before and can get it to download and unzip the files (using a python script) but as we have over 600 workflows on the server I cant automate this due to the time it takes to run and the server being setup to cancel long running jobs. Am I missing a trick here? Is there a quicker way to download all the XML workflows rather than the way I have is setup just now where it pulls in 1 at a time and takes a few seconds to download each one?
... View more
We have a batch macro which pulls in data from numerous spreadsheets and consolidates it into one concise dataset of about 6 columns. It runs fine and produces the expected data which can be viewed in the outgoing green arrow on the tool OR in attached browse tool. However when trying to add additional tools after the macro they will not recognize the column names. For example the select tool will only show "Unknown" Even after running the workflow that contains the macro to populate it with data the tools will still not pick up the column information. The macro itself has a select tool before output where the dynamic column is deselected so the macro ONLY outputs the 6 columns each time so there shouldn't be a variation in the output that the workflow can't handle. I have searched the community and tried the various solutions to similar problems but none seemed to work. We are using 2023.2 Thanks!!!
... View more
