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”: [ [ “R...
dimche_saveski's avatar
dimche_saveski
New Contributor III
6 years ago

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
6 years ago

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
    6 years ago

    @skodali

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

    BR

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

      @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?

      • dimche_saveski's avatar
        dimche_saveski
        New Contributor III
        6 years ago

        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