Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

Outer-Join two CSV

New Contributor

book_1.csv

field_1, field_2, gender
aaa,bbb, 0
aaa,bbb, 1

book_2.csv

id, gender
0, Female
1, Male

new_book.csv

field_1, field_2 , gender
aaa,bbb, Female
aaa,bbb, Male


My fileflow:

GetFile -> SplitText ->Extract Text


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

1 REPLY 1

Super Guru

@João Bernardo

You can use either QueryRecord processor with SQL kind of case statements

(or)

LookUp record processor with simplekeyvaluelookup service

(or)

ReplaceTextwithMapping processor


Please refer to this link for more details usage of these processors.