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!

[Donna_Boj]

Hi Chris, 

As you were so good at answering my previous question, I have one more!
Is there a way to remove empty rows from the CSV file? There could be cases of this, so want to see if we can remove the empty rows from the document.

Thanks in Advance!!