Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Can someone show me how to create a LookUp Table in Alteryx?

I am working on the interactive lessons from Alteryx Academy. One of the videos asks you to create a LookUp Table directly in Alteryx. I have no idea how to do that. 


It sounds like you'll need to use the Text Input tool.  Type the field names on the first row, and data on rows below.

You can also use the Paste function to use data from the clipboard.


Hey @brendanslu7  Here is a simple workflow with and example of what you might be looking for. In this workflow you would have your data table and then a lookup table (essentially what a vlookup would do in Excel) that contains a column of values to search for and then when they are found what they should be replaced with.