Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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