Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Creating Unique Record IDs Based on Criteria

Highlighted
6 - Meteoroid

Hi there,

 

I'm trying to create unique record IDs in order to group Actual and Plan.

 

Department #DescriptionWork NumberProject DescriptionMonthCategoryNumber of EmployeesNumber of Interns
1CatA-123ABC ProjectJanuary,2019Actual185264
1CatA-124ABC ProjectJanuary,2019Plan177641
3DogA-125ABCD ProjectJanuary,2019Actual185264
3DogA-126ABCD ProjectJanuary,2019Plan177641

 

I'd like the final table to look like this:

 

Department #DescriptionWork NumberProject DescriptionMonthActual Number of EmployeesPlanned Number of EmployeesActual Number of Interns

Planned

Number of Interns

1CatA-123ABC ProjectJanuary,2019181752645264
3DogA-125ABCD ProjectJanuary,2019181752647641

 

So far, what I have created for my workflow looks like this:

 

Department #Cost Center DescriptionWork NumberProject DescriptionMonthActual Number of EmployeesPlanned Number of EmployeesPlanned Number of InternsActual Number of Interns
1CatA-123ABC ProjectJanuary,201918[Null][Null]5264
1CatA-123ABC ProjectJanuary,2019[Null]175264[Null]
3DogA-125ABCD ProjectJanuary,201918[Null][Null]7641
3DogA-125ABCD ProjectJanuary,2019[Null]175264[Null]

 

How should I go about this? 

 

Thanks!

Highlighted
Alteryx
Alteryx

hi @lil_t ,

 

using your current data table that you have created you can use a summarize tool to get your final table.

 

bpatel_0-1577737611649.png

 

i hope this helps or is on the right track!

Highlighted
Alteryx
Alteryx

Hi @lil_t ,

 

It looks like you will want to cross-tab your category column. Please see if this example helps.

 

Best,

Connor Kelleher
Senior Inside Sales Engineer
Alteryx
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @lil_t ,

 

Attached is an example showing how to get that done.

I've used a multi-row tool in the middle to standardize the worknumber and the rest was a matter of cross-tabbing and transposing.

 

Let me know if that works for you.

Best,

Fernando Vizcaino

Highlighted
6 - Meteoroid

Thank you

Labels