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?

Alteryx License Example.xlsx

Developer

Accepted answers

ccanterman

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.

New Workflow1.yxzp

All comments

ccanterman

Maybe something like this?

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

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

New Workflow1.yxzp

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.

0815-ScottC1971.yxmd

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.

ccanterman

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

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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703