field_1, field_2, genderaaa,bbb, 0aaa,bbb, 1
id, gender0, Female1, Male
field_1, field_2 , genderaaa,bbb, Femaleaaa,bbb, Male
My fileflow:GetFile -> SplitText ->Extract TextI have two CSV files (book_1 and book_2) and I want to create a new csv ( new_book) that contains the gender in Male Female instead of 1 and 2. But I have no idea on how to do it.
You can use either QueryRecord processor with SQL kind of case statements
LookUp record processor with simplekeyvaluelookup service
Please refer to this link for more details usage of these processors.