I was trying to figure out how to use a lookup transform, but it doesn't seem obvious.

how would i do that?

It really is a 1 or 2 time thing that...

I was sort of coming to that conclusion, but am uncertain how to do it.....

Do I make a single derived column that replaces the value of the Gender field in...