Grouping Data in Alteryx

[acotta17]

I'm currently working on a project and could use your expertise in grouping data.
Here is an example of what I’m trying to achieve.

NOTE: Column Item is what I have in my data and Column Group is what I need as output. Also, this is just a sample list. My actual list is pretty extensive with lots of data that I cannot pre group into and then match.

Items	Group
Xiaomi TV electronics	Electronics
Electric light set	Electronics
Headphones wired Bluetooth gift electronic	Electronics
Painting Set (watercolors included) stationery	Stationery
Greeting Card stationery	Stationery
Stamp papers	Stationery
Notebook (100 pages)	Stationery
Diwali Gifts Large Box	Diwali
Diwali Gift Set	Diwali
Diwali Chocolate Pack	Diwali

Any guidance or tips would be greatly appreciated! 

[OTrieger]

@acotta17 
IT is a bit hard to answer your question without knowing how the data looks like, but you can do it with Summarize Tool Group on Group and Group on Items

[acotta17]

@OTrieger 

I apologize for the confusion. The only column I have in my data is Item. I want the group column to be generated basis the Item column.

[OTrieger]

I see. You are doing it as you know what each item is and therefore you know to which category to assign to it. There is no magic here, you can do it by creating a long formula that defining each item and then create it or by external file that has a mapping between the items and the groups

[abacon]

@acotta17 another option is to have a lookup table of which group each item should go into, add that into the workflow and join to the data source. I find that easier than using formulas as it's easier to update the lookup table than go into the workflow and constantly update a formula. But the formula option would get you what you are looking for.

[Qiu]

@acotta17 
Agree with @OTrieger , there is no magic here, we have to tell Alteryx Which item belongs to whch category, even with Key Words.

Maybe an External reference library should be in place.

[acotta17]

Please review the updated question

[OTrieger]

@acotta17 
Automation, even AI, is not capable of thinking capabilities as human, you need to define logics or provide data to creates it's knowledge to make decisions. This is the same with AI, AI is using very complex logics to "think" as if the machine is thinking.

Therefore something, such as data or logics is needed to help Alteryx make decision what is what.

[nagakavyasri]

@acotta17 if there is any external mapping available then you could use that as reference and use 'Find and Replace' tool to get the 'Group' column else categorizing them based on keywords is one solution.