When I run an iterative macro from inside of it, the results I will see will be from the first iteration only (even if normally the macro would take much more iterations to finish). Is it possible to set the number of iterations for the macro to run before it gives me the results, and in an easy an convenient way? And I mean: within the macro itself, not when it's used in another workflow (then I'd use the Maximum Number of Iterations option). Example: Let's say I have an iterative macro that runs 100 times. For the first 15 iterations it gives me exactly what I need, but after that it starts to fail. I would like to see the input it's getting in iteration #16 to troubleshoot.
... View more
Good Day, Is there anyone from you who could write an autoexec.bat file that will copy the sheets to another excel file? The copy will be a clone with out any changes in the file formats. I am not very much knowledgeable on this but I am thinking maybe this will works since I have tried lot of things to solve this. I have a master file with multiple sheets and I would like to add a sheet coming from different excel file. I have tried many ways like using the blob tool but it is not working. Below are two sample excel file. The goal is to copy the sheet from Control.xlsx to Financial sample.xlsx without any changes in its formats. Financial sample is the master file. Looking forward for some bright ideas there. Kamen
... View more
Hi, i have following data set, using multi row formula , i want to get expected output, since i have multiple columns i dont want to use crosstab Acc NAME SAF ID SA 100A 100B RM VA DF 100D 100F RM VA Expected output: Acc NAME SAF ID SA 100A 100B RM 100B VA 100B DF 100D 100F RM 100F VA 100F
... View more
Alteryx Community, I am looking for some help to let Alteryx to read and output password protected Excel Files. Besides using R or Python, look like there're old discussions on using a macro. However, look like that macro was taken off the shelf some time ago. Anyone can offer help if the macro is now resurrected? Much appreciated. I am searching if we have a macro to 1) Output to an Excel file with password protected 2) Be able to access an existing password protected file to then be able to append to it Many thanks!
... View more
Hello all, I have this task where I should predict too many targets, According to my data, I think Neural Network is the best approach since my data does not have any obvious relationship and it's big. How can I apply this in Alteryx where I can insert a multiple inputs and expect to see multiple targets. Thank you.
... View more