Add Row to Table

[ScottC1971]

I am trying to create a flow to help manage software licenses.  Current my spreadsheet shows a listing of licenses that are being used. There are summary columns that show the total number of licenses, total number of used licenses, and total number of available licenses.

What I would like is create a table that shows 5 license keys if there are 5 license keys. Then I can join to the table with the data that shows there are two license keys without a username assigned.

Here is a sample what I am trying to achieve

License Key User Name
ABC123 John Doe
ABC123 Sam Doe
ABC123 Jane Doe
ABC123 Unassigned
ABC123 Unassigned

I thought that using the Generate Rows or Multi-row tool might help me to do this but I haven’t been able to seem to find a way to get this done. Can anyone assist me?

[Carolyn · Accepted solution]

Maybe something like this? 

I split your xlsx file into a list of assigned licenses (top path) and the total licenses (bottom path). 

I created a new field called "License #" (which is poorly named but I couldn't think of anything else) to become the Generate Rows key. For ABC123, my 2 people, Andy and Bob, were given License #1 and 2. Then in the bottom path, I did a Generate rows to get 1-5 for ABC123. 

When I put it all together, it leaves me with 3 Unassigned on the Right Output. 

[Qiu]

@ScottC1971 
I would use the Unique tool to pick one record for each license number then use the Generate Rows tools to generate the records for unassigned license based on remaining license.

[ScottC1971]

@Qiu and @Carolyn , thank you both for responding as fast as you did.  I am still fairly new to Alteryx, so I appreciate your input.  Not trying to pick one solution over another and cause a fight here but is there a solution that is more efficient than the other.  It would be great to put that idea into context here.

[Carolyn]

@ScottC1971 - That's easy - mine's better :D 

I would say that @Qiu's is more efficient. I appreciate how their solution uses fewer tools and it generates the rows without the way I had to go about it. That being said, I don't see it as easily, so, for my brain, my solution makes more sense and is what I would implement in my job. 

When I was learning Alteryx, I would often ask my amazing Alteryx Engineering Rep (Mike!) the same question. His response was that as long as it worked, I was good. Instead of trying to build the most efficient/fewest tool solution, to focus on building something that made sense to me and learning Alteryx. The efficiency would come later. Now, when I look at some of my earlier workflows, I laugh a little and can do them way better now. But at the time, I did them to the best of my ability and that's what mattered. 

All of which is to say - play with them both and go with whichever solution makes more sense to you.

[ScottC1971]

@Carolyn I really appreciate what you said and will take it to heart.  Something that works for me over the "right" solution!  Thanks much for your help!

Scott

[Qiu]

@Carolyn 
Agree with you. I dont usually persue the most "efficient", "Fewer tools" solution.
I am tryting to look at the data and try to think about dynamic one to cater the data possible changes.

Nice talk!