Create varying number of rows using multirow

Question

Is there a way to conditionally create a row of data, only populating some of the fields on output?  My input file has an 'orgid' field which is the key field -  the output file needs to have 3 rows for each unique orgid.  example -

orgid 123 has 3 rows on input, no changes needed and all 3 rows are written out with no changes.

orgid 456 has only 1 row, 2 new rows need to be generated, carrying the orgid only, as i don't want the data duplicated from one row to the next.  The recordID can be retained for output on records 2 and 3

orgid 789 has only 2 rows, 1 new row needs to be created.

orgid 999 has 3 rows - all 3 records written out as with no changes.

i've tried to work with 'generate rows' and 'multi-row formula' tools with no success.

attached are sample input and output files.

thanks!

Samp for multirow JH .csv

Output Samp for multirow JH .csv

atcodedog05 · Accepted Answer

Hi @nwhite

Here is a workflow for the task.

Output: (As expected output)

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Christine_Assaad · Accepted Answer

Hi @nwhite

Please check out the below. Hope it helps. Cheers!

nwhite · Accepted Answer

WOW!  thank you so much for the speedy reply, took me longer to type up the message than for you to create a solution - that's fantastic!