Support Questions
Find answers, ask questions, and share your expertise

How to extract particular column data and assign to custom attributes using Nifi?

How to extract particular column data and assign to custom attributes using Nifi?

Rising Star

Hi,

I have a scenario where I will be reading csv file, from that i have extract column value(s) and assign to custom attribute(s). From custom attributes I have to form a json file.

I have gone through the extractText processor we need to pass regular expression to get the text,  not quite understanding with that, is there any better and easy way to get above requirement?

sample csv file.

ID

Description

Status

project

8075

John

Done

xyz100

 

Extract ID and project and create custom attributes like projectID=ID and modelProject=project.

 

Thanks

--Murali

 

1 REPLY 1
Highlighted

Re: How to extract particular column data and assign to custom attributes using Nifi?

Contributor

Did you already think about to transform your csv to json and then rebuild it with JOLT?