Hello, I have a list of 20k email addresses. The goal is to convert the list to a csv, but limit each file by 500 records. I'm sure I need a cross tab, but stuck on how to create the csv: START email user1@domain.com user2@domain.com user3@domain.com END user1@domain.com,user2@domain.com,user3@domain.com (file 1.csv) user501@domain.com,user502@domain.com,user503@domain.com (file 2.csv)

Vertical list to horizontal csv loop 500

Hello,

I have a list of 20k email addresses. The goal is to convert the list to a csv, but limit each file by 500 records. I'm sure I need a cross tab, but stuck on how to create the csv:

START

user1@domain.com
user2@domain.com
user3@domain.com

END

user1@domain.com,user2@domain.com,user3@domain.com (file 1.csv)

user501@domain.com,user502@domain.com,user503@domain.com (file 2.csv)

Datasets

Developer

Accepted answers

FinnCharlton

Hi @joesparty , here's how to write one csv per 500 records:

We use a record ID to number the records, then calculate a file name based on that number. Each file name will be attached to 500 records. We can then use the 'Take File Name from Field' option in the Output tool to write each set of 500 records into a separate file. Hope this helps!

500 records per csv file.yxmd

All comments

FinnCharlton

Hi @joesparty , here's how to write one csv per 500 records:

500 records per csv file.yxmd

joesparty

That does help with the 500 rows. Any suggestions on how to concatenate the names before writting to csv?

joesparty

The summarize, not cross tab, was the tool to use.

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335