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

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

Hello @dimche.saveski
I’m trying to get those results into a single target path.
Similar to this image
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?