Good morning/afternoon/evening all, Just want to thank everyone in here for your excellent explanations. I am learning Alteryx to revamp some reports my department uses at work and have made some good progress on a specific report, but I'm needing a bit of help on how to format a couple things. I'm working a vendor report, which has vendor names, product names, identifiers, and some states where the products are sold. Below is a sample table drafted up of what my filtered down data looks like. I was able to concat the states, which is something that we desperately needed. Vendor NameVendor IDProduct NameProgram NameProduct IDStates Sold (concatenated)ABC Corp1234TestProdABC PRODx1234AZ, CA, TNABC Corp1234TestProd2BCD PRODy1234AZBCD Corp3213ProdTest3DDD PRODz2343NMBCD Corp3213ProdTest4EFG Prodq1122TX So what I'm trying to do next is to Group by Vendor name, and would look something like this Vendor NameABC Corp Vendor ID1234 Product NameProgram NameProduct IDStates Sold TestProdABC PRODx1234AZ, CA, TN TestProd2BCD Prody1234AZ So basically, I'm just trying to group by Vendor Name, and display a list of products by each vendor in this format (or something similar). Unfortunately, multiple vendors may have the same Vendor ID, so i'm unable to use that as a reliable criteria to filter and sort by. One option I do plan to implement is to give each Vendor a separate internal ID # even if they are linked, as we need this split by each individual Vendor alone. Any advice would be appreciated. I'm still pretty new to this so if there's an easier way to get there, I'm all for it!

Couple questions about Organizing / Exporting Data

Good morning/afternoon/evening all,

Just want to thank everyone in here for your excellent explanations. I am learning Alteryx to revamp some reports my department uses at work and have made some good progress on a specific report, but I'm needing a bit of help on how to format a couple things.

I'm working a vendor report, which has vendor names, product names, identifiers, and some states where the products are sold. Below is a sample table drafted up of what my filtered down data looks like. I was able to concat the states, which is something that we desperately needed.

Vendor Name	Vendor ID	Product Name	Program Name	Product ID	States Sold (concatenated)
ABC Corp	1234	TestProd	ABC PROD	x1234	AZ, CA, TN
ABC Corp	1234	TestProd2	BCD PROD	y1234	AZ
BCD Corp	3213	ProdTest3	DDD PROD	z2343	NM
BCD Corp	3213	ProdTest4	EFG Prod	q1122	TX

So what I'm trying to do next is to Group by Vendor name, and would look something like this

Vendor Name	ABC Corp
Vendor ID	1234

Product Name	Program Name	Product ID	States Sold
TestProd	ABC PROD	x1234	AZ, CA, TN
TestProd2	BCD Prod	y1234	AZ

So basically, I'm just trying to group by Vendor Name, and display a list of products by each vendor in this format (or something similar). Unfortunately, multiple vendors may have the same Vendor ID, so i'm unable to use that as a reliable criteria to filter and sort by. One option I do plan to implement is to give each Vendor a separate internal ID # even if they are linked, as we need this split by each individual Vendor alone.