Adding specific data sets for each row

Question

Hi All,

Here's the question that I have. My file does essentially look like this:

Person 1XXPerson 2YYPerson 3ZZ

Single rows for each record.

I now want to add specific data "blocks" to those rows, so the result would basically look like this:

Person 1XX123  456  789Person 2YY123  456  789Person 3ZZ123  456  789

So I'm adding the "block" with 123; 456; 789 for every single record and the added rows are blank, aside from the information in the "block".

This is done easily manually, but the set I am looking at has a couple thousand rows, so I'd obviously prefer a smarter solution 🙂

Thank you!

echuong1 · Accepted Answer

Probably not the most effective method, but you can append the two lists together to get all combinations, then use multi-row formulas to bring the null values back. See attached for an example. Let me know if that works!

scollier1993 · Accepted Answer

Thank you!

That pushed me in the right direction. Instead of using the multi-row formula tool, I separated my "block" data set between the first row and the remaining rows.

First Set:

Block123

Second Set:

Block456789

I then did the Append Fields for my original file and the file with only one row, then I did the Append fields with the original file and the file that has all remaining "block" records and used the formula tool to basically empty all columns in that data set.

Then I joined those two and sorted.

This sounds like more work, but because I had so many fields in my file, it was easier that way because I didn't have to create 30 multi-row formula tools but was able to empty them all in one formula tool.