Create CSV via Fusion - Need different data to show on separate rows | Community
Skip to main content
Donna_Boj
Donna_Boj
Level 3
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
Community Advisor
ChrisStephensCommunity AdvisorAccepted solution
Community Advisor
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
    Level 3
    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...