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
Alteryx

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