Alteryx Community is the go-to hub for analytics professionals to learn, connect, and solve problems faster. Explore expert-led discussions, product resources, and best practices to build, automate, and scale your analytics workflows with Alteryx.
Hi there :) I have a batch macro that opens multiple Excel files since the schema changes. However, at times there will be a file that is corrupted and the macro doesn't work. I found online a Python script that would identify the files whose Error Message says "File is Not a Zip File". I was planning on filtering those…
If you want to move or copy files without using cmd or powershell solutions you can now install this tool made with the Python SDK. You can choose to keep the filenames the same but you can also rename them at the same time. It's a yxi package you can download and install from my Github site. Happy moving!…
So I'm running workflow in Alteryx Designer desktop, and every time I run the python in Alteryx it returns error that is "name 'jedi' is not defined". I tried to debug it by running the jupyter-notebook.exe at C:\Program Files \Alteryx\bin\Miniconda3\envs\DesignerBaseTools_vEnv\Scripts and the same error happens.
My current Python Code : (\<Shares|\<Shares\:|[^\-]Share\:|\<Underlying Share\:|\<Exchange|\<Exchange\:)\s\s\s\s+([[:alpha:]|\s|\-]+)\s I'm looking to extract the following : 1. Share Name [Share / Shares / Shares: ] 2. Ticker Code [ REUTERS : / Bloomberg Ticker: / Bloomberg Code: / Reuters Code: / RIC: / Bloomberg: ] 3.…
Hi all, I have been looking for a way to crack open a protected PDF for a specific use case I had and I created a Python solution wrapped into Alteryx in order to do it. It has done what I needed to do, granted the output of the tool I made needs to be parsed and REGEX-ed accordingly to get certain fields. Sample of what…
i am getting an error (details on text file) while running a python script that install a library named 'camelot-py'. the error is : - A module that was compiled using NumPy 1.x cannot be run in NumPy 2.2.6 as it may crash. To support both 1.x and 2.x versions of NumPy, modules must be compiled with NumPy 2.0. Some module…
Hi Alteryx Community! We all know the struggle of taking unstructured data (like PDFs) and trying to create a perfectly formatted Word report. While the standard Reporting tools are great, sometimes we need more flexibility—especially when it comes to inserting dynamic images (like team profiles) or digital signatures into…
Hi Alteryx Community! 👋 We all know the struggle of taking unstructured data (like PDFs) and trying to create a perfectly formatted Word report. While the standard Reporting tools are great, sometimes we need more flexibility—especially when it comes to inserting dynamic images (like team profiles) or digital signatures…
Hi All, I have been running into issues every time that I try and execute a python script using the Alteryx run command tool. Screenshot of the error below. I did read through some of the other posts on run command errors but couldnt seem to rectify the error. Appreciate it if you could look into this. Also - I have tested…
Need a help to build the expected result shown in screen shot and also in attached file. As we see in the Row number 3. We have ITEMCODE= 8PA2543YDNEWMOD2 and for Like Profile=8PA2543YDNEWMOD1 which has a like profile= 310006 in row number 2. so we need the expected result for 8PA2543YDNEWMOD2 as shown in Expected result.…
It looks like you're new here. Sign in or register to get started.
