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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Embed Lookup Tables in Workflow

Asteroid

Hi!

I am working with a workflow that uses multiple VLOOKUPS (in the form of Find and Replace tools). I am trying to create a series of lookup tables to make the workflow simpler, as I am trying to turn it into an app where the end user will only need to specify the inputs. I am looking for a way to embed these lookup tables in my workflow so that there is no need to re-input lookup tables. I have tried this with the Text Input tool, but my lookup tables are quite large and cannot be fully uploaded in the Text Input tool (the tools imports about 500 rows, but I have about 3000 rows in the table). Is there another way to do this/or a way to add the rest of my data to the Text Input tool?

Any help is appreciated!

Alteryx
Alteryx

Hi @grsomer,

 

I've used Text Inputs with more than 3000 rows in the past. You can copy and paste your data into them for your lookups. Obviously it's a bit slower and clunkier but it should work as long as the data isn't overly large.

 

Try and copy and paste and let us know how that goes.

 

Alternatively, you can look at using multiple Text Inputs and Union to build up the lookup tables. Or could you use the Generat Rows tool to build out the lookup?

 

Luke

Asteroid

The copy and paste worked perfectly! Thanks so much!

Labels