Lookup button greyed out

I have the 7 day free trial for now. I have to do data Migrations in healthcare. This requires a lot of data mapping and transforming fields. Before purchasing I want to make sure it will do what I need to do.

it seems the lookup would be how I would do it.

I’d have a table like this

mapping table
source data value, new value

Then I’d use the lookup function and when I hit source data value match I swap with new value. But lookup is grey out. What am I doing wrong? I have the two tables pulled into the window.

You have select both tables. Also, the table that is on top of the page will be your source.

1 Like

As @mk2109 says, you need to select 2 items in the center pane to do a Lookup, Join, Cross etc. This confuses a few people. So in the next release of Easy Data Transform all the buttons will be enabled, but you will get a helpful message if you click Lookup when you don’t have 2 inputs selected. You will be able to revert to the old behaviour by checking a box in preferences.