The condition has to be done before i transform as the data coming in differs for example

if col005 = 'E' it's numeric if col005 = 'Z' it's character