Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Nifi Convert Json 2 Csv dyanmically but Csv Format is not correct

Nifi Convert Json 2 Csv dyanmically but Csv Format is not correct

New Contributor

I have used ExecuteSQL where i am getting Avro Convert Avro to json -->split Json-->InferAvroSchema --> ConvertJson2Avro--> ConvertRecord --> MergeContaint ->PutFile

I have sucessfully generated Csv file but Csv file looks quite Odd as each cloumn header Adding Duplicate on each line may i know what i have missed

I have input with Large Jsonarray like

[

{

"ProductionDay": "2018-12-01 00:00:00.0",

"LostBOE": 0,

"Tag": "100101806104W600"

},

{

"ProductionDay": "2018-12-01 00:00:00.0",

"LostBOE": 0,

"Tag": "100101806104W600"

},

{

"ProductionDay": "2018-12-01 00:00:00.0",

"LostBOE": 0,

"Tag": "100101806104W600"

}

]

Also attaching flow file screens

108010-csvwrongcolumn.png107999-flowfile.png

Don't have an account?
Coming from Hortonworks? Activate your account here