Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Mass upload of search terms in Dimensions, workspace

HelenaRosey
Level 1
Level 1

I am creating a table in workspace, and I have dropped Product as a dimension into the table, however I only want the table to display 300 products out of 35000 products. Is there a way to upload all the product names at once or filter them? I can only seem to search individually?

 

2 Replies
PratheepArunRaj
Moderator
Moderator

Dear HelenaRosey,
I would use segmentation since creating segmentation based on the list is easy after the introduction of 'Equal Any Of'. You just need to include the Products with a comma separator.

PratheepArunRaj_0-1589825735293.png

Thank You, Arun.

 

brentrad
Level 5
Level 5

Have you created classifications for the Product variable? I've found that this has been a big help when it comes to handling dimensions with a ton of values, such as Campaigns. 

 

For example, let's say that the 300 products you referred to are "T-shirts". You could create a classification called "Product Category", and use "T-shirts" as one of the values when you upload the classifications. This will allow you to create a segment that will limit the Analysis Workspace table to only show "T-shirts".