Forum Discussion

aditya_gupta41's avatar
aditya_gupta41
Contributor
3 years ago
Solved

Writing Array in CSV without formatting

Hello Experts,

My input contains 2 headers. In one header, the value is in JSON format.

I am trying to write it in a CSV file but as this is in array format, I am getting below error:

I tried using .toString(), but then it negates all the quotes.
I want JSON format to be intact. Below is the format in which I want CSV to be created:

Thanks in Advance

pipeline

3 Replies

    • aditya_gupta41's avatar
      aditya_gupta41
      Contributor
      3 years ago

      Now it is coming as :

      Require it as no \ and in single column. I think i might need to change something in CSV formatter snap.

  • aditya_gupta41's avatar
    aditya_gupta41
    Contributor
    3 years ago

    Its done. Escape character in CSV formatter is suppose to be blank.

    Thanks Aleksandar for your quick help.