cancel
Showing results for 
Search instead for 
Did you mean: 

Convert CSV to required format

skodali
New Contributor III

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

1 ACCEPTED SOLUTION

dimche_saveski
New Contributor III

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

View solution in original post

11 REPLIES 11

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.
image

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

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

Pipeline results were like:
image

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