I am totally new to Alteryx, and I haven't even gone through our company's Alteryx training yet. I apologize if this is an easy one. I have a spreadsheet with a list of employees, their titles, if that title is an HR related title, and the company they are employed by. Here's what I have CompanyEMPL_IDEE has HR Related Title?ABC1YABC2NDEF3NDEF4N I need to output a list that shows whether or not that company has an employee with an HR Related title What I want CompanyCompany has HR Related title?ABCYDEFN I don't think I need the exact steps with all the details, but I really need to know the overall process and what tools to use to achieve that result. Thanks,

Hey @csh8428, I'd use the summarize tool to group by Company and Max(HR flag): @LordNeilLord Part time Tableau, Part Time Alteryx. Full Time Awesome

Output matches from one cell if value exists anywhere in another column

csh8428

I am totally new to Alteryx, and I haven't even gone through our company's Alteryx training yet. I apologize if this is an easy one.

I have a spreadsheet with a list of employees, their titles, if that title is an HR related title, and the company they are employed by.

Here's what I have

Company	EMPL_ID	EE has HR Related Title?
ABC	1	Y
ABC	2	N
DEF	3	N
DEF	4	N

I need to output a list that shows whether or not that company has an employee with an HR Related title

What I want

Company	Company has HR Related title?
ABC	Y
DEF	N

I don't think I need the exact steps with all the details, but I really need to know the overall process and what tools to use to achieve that result.

Thanks,

Common Use Cases

Accepted answers

LordNeilLord

Hey @csh8428,

I'd use the summarize tool to group by Company and Max(HR flag):

HR Flag.PNG

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover

All comments

LordNeilLord

Hey @csh8428,

I'd use the summarize tool to group by Company and Max(HR flag):

HR Flag.PNG

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover

NicoleJohnson

You might just be able to use a Summarize tool, if your data is formatted like the sample you provided... Choose Group By for Company, and then Max for "EE has HR Related Title?" field... this ought to give you N if all the employees are N's, but Y if there is an HR related title/Y response for any EE in that company.

EDIT: In other words, do what @LordNeilLord suggested

Hope that helps! And nice job jumping right in to Alteryx & the Community!!

Cheers,

LordNeilLord

@NicoleJohnson great minds think alike

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover

csh8428

That worked.. Thanks!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703