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.
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.