In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Reading database rows in Python tool

Roche
8 - Asteroid

Hi everyone, 

 

I am trying to read a database into the python tool to then use specific information, however I am not sure why Alteryx is giving me an error and why read is not defined (Alteryx.read("#1"))

 

The steps I need: read the database in, create a variable that defines the specific cell from which I need the information, later in the code at wd.get() call that variable to read the link from the cell, write out the link to output 2 at the end of the script.'

 

Roche_0-1651060223521.png

The yellow highlighted part is where I need to call the link defined at the top.

 

 

I attach an example flow as well

 

Thank you for helping, 

 

Rouche

2 REPLIES 2
MatthewO
Alteryx Alumni (Retired)

Hello @Roche - I see one issue when the script reads the incoming data.

 

MatthewO_0-1651062065852.png

 

The correct syntax would be:

links = Alteryx.read("#1")

 

Roche
8 - Asteroid

Hi Matthew, thank you.  Thats weird thoug...that I would have typed it like that.  Will add a new attachment.  The code still give me an error and I do not know why.

 

Labels
Top Solution Authors