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

[J1ret]

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.

 

[IvanBebek-iX · Accepted solution]

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

[J1ret]

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.