question Problem : while parsing JSON formatted CSV file using Nifi ? in Archives of Support Questions (Read Only)

Problem : while parsing JSON formatted CSV file using Nifi ?

sshringi003 — Sun, 18 Aug 2019 08:07:20 GMT

Hi folks,

I am facing issue in Nifi while parsing JSON formatted CSV file, which processor should be selected or not. i have attached input file, you can go through and let me know.

My output should be like

Name : abc

Age : 24

Address_city : chennai, Address_state : TN, Address_zipcode : 600234

I would appreciate for help me.

Thanks !

Re: Problem : while parsing JSON formatted CSV file using Nifi ?

Shu_ashu — Sat, 13 Jan 2018 13:32:08 GMT

@Surendra Shringi

The question got addressed here https://community.hortonworks.com/questions/159780/parse-file-in-nifi.html

Need to make some config changes to the processors that are used in the above community link to work with the sample data.

Changes in Extract Text processor:-

Change existing Age,Name Property values in Extract text processor

Age

\|.*\|(.*?)\|

Name

\|(.*?)\|

Add new id property as

^(.*?)\|

Changes in Replace text:-

Change the below property

Replacement Value

${id},${Name},${Age},${Address_city},${Address_state},${Address_zipcode}

I think these are the changes you need to make to work the NiFi process to work with your input data.

Re: Problem : while parsing JSON formatted CSV file using Nifi ?

sshringi003 — Sat, 13 Jan 2018 13:51:37 GMT

Thanks @Shu

For such a nice help.