Forum Discussion

skodali's avatar
skodali
New Contributor III
6 years ago
Solved

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

    BR
    Dimche Saveski

11 Replies

  • dimche_saveski's avatar
    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

    BR
    Dimche Saveski

    • skodali's avatar
      skodali
      New Contributor III

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

      • dimche_saveski's avatar
        dimche_saveski
        New Contributor III

        @skodali

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

        BR