Convert CSV to required format

[skodali]

Hello All,

I’m trying to Conver a CSV file to a JSON Format. Can anyone provide some inputs on how to achieve the required output format into a mapper?
Required Format:
{
“values”: [
[
“Row1-Column1 Data”,
“Row1-Column2 Data”
],
[
“Row2-Column1 Data”,
“Row2-Column2 Data”
]
]
}

Thanks,
Sasank

[dimche_saveski]

N number or rows should be bigger than number of expected input records. If you expecting 100 records , set that number 700 , just to be on the safe side.

P.s Updated the pipeline and the file
BR

[skodali]

@dimche.saveski
Updated pipeline is resulting in different structure compared to the required format.

[dimche_saveski]

I’ve tried to achieve structure like your original post requirements, on the left is result on the right requirements:

Maybe you like to achhieve Row1 : Column1 key value pairs?

BR

[skodali]

@dimche.saveski

Updated pipeline almost resulted the desired format but “values” should not be the target path. Values text should be part of JSON like:

Pipeline results were like:

[dimche_saveski]

Just add “requiredResult” before the “values” field in the last mapper of the pipeline, like this