Support Questions

Find answers, ask questions, and share your expertise
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

Extract the CSV fields from each record and add them as attributes to Corresponding Flow File.

New Contributor


I have Zip file with some txt files and index file(csv) inside. How to add the fields in the each CSV record as attribute to Txt files matching its filename?

List of Files:

  1. a.txt
  2. b.txt
  3. c.txt


filename, Date, Origin, Owner

a.txt, 20190103, AT, WU

b.txt, 20190103, CT, WU

c.txt, 20190103, OT, XO


New Contributor

Once you use UnpackContent to unzip the file, each flowfile will be one CSV. You should then be able to use ExtractText to pick out the fields from the CSV that you want to turn into attributes. Use a regex to tell ExtractText where to find the value for each attribute.

New Contributor

Hi @Ryan Shirley

Thank you for your response. But the zip file have some .txt files along with one .csv file. I want to add the csv field values as new attributes to .txt files if its filename matches.

let's say i have one text file 'a.txt' and from the csv file i extract the values of fields like 'origin', 'owner'. How to add these values as attributes to 'a.txt' file?

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.