Convert CSV to required format

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

Hello @skodali

I tested a bit with your issue and come up with some solution. Please check this pipeline and the csv test file, and see if that can help you.
test2_2020_06_12.slp (8.8 KB)

and csv file structured like screenshot bellow
Screenshot_2

BR
Dimche Saveski

1 Like

Hello @dimche.saveski
I’m trying to get those results into a single target path.
Similar to this image

@skodali

I’ve updated the example pipeline in the post above to achieve the desired json structure, please check it

BR

@dimche.saveski
Thanks for the help. The updated pipeline helps to achieve the desired format, but its static to only get 2 rows of data. What if I have ‘n’ number of rows?

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

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

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

@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:

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

1 Like

Thank you very much @dimche.saveski
It worked!

@skodali

Glad to help you

BR