โ06-11-2020 06:22 AM
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
Solved! Go to Solution.
โ06-11-2020 08:52 AM
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
BR
Dimche Saveski
โ06-11-2020 08:52 AM
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
BR
Dimche Saveski
โ06-11-2020 10:29 AM
Hello @dimche.saveski
Iโm trying to get those results into a single target path.
Similar to this image
โ06-11-2020 02:57 PM
Iโve updated the example pipeline in the post above to achieve the desired json structure, please check it
BR
โ06-11-2020 03:48 PM
@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?