Need help in Converting Array output to a string which can be store in a CSV file. | Community
Skip to main content
J
J1ret
New Member
August 5, 2025
Solved

Need help in Converting Array output to a string which can be store in a CSV file.

  • August 5, 2025
  • 1 reply
  • 269 views

Hello Team,

 

I'm searching ASSGN object and trying to get the workperdate, AssignedTo ID values, post that I'm storing the data in datastore. So the workperdate is an array having collection(attached the screenshot). 

 

But Now if i try to create a CSV file for the same this workperdate is fields is null/empty. How i can simply the array collection so that it will easier to put in CSV. I have attached the scenario ss as well.

 

 

 

 

 

Best answer by IvanBebek-iX

Hi @j1ret,

 

In this case it depends how you want to save the string as, if the JSON will suffice you can use "Transform to JSON" module and save json in csv field (you will probably need to escape "," or use advanced options to add different delimiter), another option is to use classic Iterator to iterate "Work per day" items in combination with Text aggregator where you aggregate only needed data in any format acceptable for you.

 

Hopefully this helps.

 

Best regards,
Ivan

1 reply

IvanBebek-iX
IvanBebek-iXAccepted solution
Level 5
August 19, 2025

Hi @j1ret,

 

In this case it depends how you want to save the string as, if the JSON will suffice you can use "Transform to JSON" module and save json in csv field (you will probably need to escape "," or use advanced options to add different delimiter), another option is to use classic Iterator to iterate "Work per day" items in combination with Text aggregator where you aggregate only needed data in any format acceptable for you.

 

Hopefully this helps.

 

Best regards,
Ivan

    J
    J1retAuthor
    New Member
    August 20, 2025

    Thanks Ivan, I have tried the same approach one more step i did is converted that Json output(from the Transform Json module) to a string and then stored it into CSV.

     

    Terms & ConditionsAccessibility statement

    Loading footer...