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

Thank you very much @dimche.saveski
It worked!

@skodali

Glad to help you

BR