Forum Discussion

pjanapati's avatar
pjanapati
New Contributor II
3 years ago

Group By N

Hi,

I am building a pipeline where I am getting the 100 records. And I want to group 5 records and send the file to FTP. Here, for grouping 5 records I have used group by N. After this, I am unable to format the CSV data.

In csv formatter, I am getting the below error.

Can you please anyone help me on this. After group by N, how to format that data to CSV data.

5 Replies

    • Aleksandar_A's avatar
      Aleksandar_A
      Contributor III

      Or you can omit the Group By N Snap, and specify a Batch Size in the Pipeline Execute Snap.

      And in the child you just format and write the documents.

      • pjanapati's avatar
        pjanapati
        New Contributor II

        Hi @AleksandarAngelevski ,

        Thanks for the solution.
        In JSON, we have 12 records. Coming to CSV files I am getting only 2 files with 5 records each. Here we are losing 2 records. Is there any solution for this.

        Thank you.