Categorize info

[Brian6255]

Using Designer.  My data set looks like the attached.  I want to create one new column and label each row as "Dogs" or "Cats" to put them into their own group

[tim-regas · Accepted solution]

I would find a list of all dog breeds and a list of all cat breeds. Then I would join the dog breeds list to your data and anything that joins is a dog. Then everything that doesn't join, I would join to the cat breed list and everything that joins there would be a cat. Then sort through the unjoined records to see what needs to be added to your dog and cat breed list or manually adjusted.

[Brian6255]

Yes!  Thank you!  I was thinking too small and trying to stay within the same report.  By pulling in a new dataset and joining, that will take care of it.  Thanks!

[tim-regas]

Happy to help!