Create CSV via Fusion - Need different data to show on separate rows

[Donna_Boj]

Hello,

Hoping someone can assist.

I need to display different field level data on different rows of a CSV file I create via Fusion.
E.g. in Workfront the users specifies how many Leads they need via a dropdown field and then fields appear for each Lead for them to fill in:
Name 1, Date 1
Name 2, Date 2
Name 3, Date 3
I need those fields to be placed on separate rows on the CSV but I am struggling to find a way to do it.

Any help appreciated! Thanks

[ChrisStephens · Accepted solution]

So just to make sure, there is a field where they select a number, and then you need to create a CSV with a new entry for each number formatted as 

Name #, Date #

If that's correct, here's what I would do.

1. Setup a repeater that will repeat for how ever times they selected.
2. Setup a text aggregator
   1. Source module is the repeater
   2. with the value Name {i from the repeater}, Date {i from repeater}
   3. Toggle advanced options
   4. Make the row seperator a new row
3. Setup a WF document upload module
   1. Document name = {The name you want}.csv
   2. File content = text aggregator value

[Donna_Boj]

Hi Chris,

Amazing! We have taken your 'Text Aggregator' module suggestion and applied this to our scenario and it has worked.

Thank you so much!