How to generate the gender from Firstname in Tmap?

[profuse]

Hi,

Is there a way to determine the gender based on a column that contains the individuals First Name in Tmap?

Thank you

[lokeshbabu]

Hi ,

First Name is static in all records ?

[profuse]

yes, my input file is a CSV file.

[lokeshbabu]

Give same sample data 

[profuse]

See attached. First Name is in column T.

TalendSampleFile01242020.csv