Create CSV via Fusion - Need different data to show on separate rows | Community
Skip to main content
Donna_Boj
Donna_Boj
New Participant
February 25, 2025
Solved

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

  • February 25, 2025
  • 1 reply
  • 601 views

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

Best answer by ChrisStephens

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

1 reply

ChrisStephens
ChrisStephensAccepted solution
New Participant
February 26, 2025

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
    Donna_BojAuthor
    New Participant
    February 27, 2025

    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!

    Terms & ConditionsAccessibility statement

    Loading footer...