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

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

Highlighted

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