Return just 5 product numbers

[tmitchell30]

I just need to return 5 of the product numbers from this column. Do you know what I need to do to perform this? If there is a formula, what would it be? I need 174566, 189877, 260004, 244474 & 114486 only.

[gabrielvilella · Accepted solution]

Assuming that you will always need just those numbers and the Product field is string, you can have a filter with this expression:

[Product] in ('174566', '189877', '260004', '244474', '114486')

[Luke_C · Accepted solution]

Hi @tmitchell30 

Another option would be maintaining a list of the products you want and joining it to your data. The resulting 'J' output of the join tool would be limited to the 5 products identified, and could be easily updated if they change in the future.

[tmitchell30]

Thank you! This worked great.

[gabrielvilella]

Your welcome! Don't forget to mark the answer as solution.

[Luke_C]

@tmitchell30 Happy to help - remember to accept the solution(s)!