Expand my Community achievements bar.

SOLVED

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

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

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

Avatar

Level 2

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!