community
cancel
Showing results for 
Search instead for 
Did you mean: 

Dev Space

Customize & extend the power of Alteryx. SDKs, APIs, custom tools, and more!
SOLVED

Custom Python Tools: How can we do column-wise operations?

Highlighted
Alteryx Certified Partner

Hey,

 

I have been trying to make my python tool do column-wise operations. From what I have read, I understand that I need to read in each row in 'ii_push_record' and then perform the operation and output all rows in 'ii_close'.

 

I am having trouble correctly reading in the records and accessing them again for output later. If anyone could provide the syntax used for storing rows into a dataframe in 'ii_push_record' , and then calling/outputting them again in the correct order in 'ii_close', I would really appreciate it. 

 

Thanks!

 

Alteryx
Alteryx

Hi @mark_oshea - it sounds like you need to perform a batch process in your tool. If you're using the Python SDK, this post has a code example for storing the incoming data that might help. We also have an abstraction layer for the Python SDK called SnakePlane that helps streamline the process of creating a tool with the SDK and a 'batch' mode option is available. @SydneyF wrote a great tutorial on how to use it here.  

Alteryx Certified Partner

Thanks! That code example is exactly what I was looking for.