Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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