how to create or update product attribute value for specific categories? Magento 2

I created an numeric attribute, and product has assigned 2 categories (parent category and subcategory), is it possible update product attribute only for subcategory? or is it possible create custom product attribute only for subcategory? This would apply for all products.

MOTOR (Subcategory)
Colecciones (Parent Category)

I need to set numeric attribute value (3) in MOTOR and that in the parent category the value is still kept at (0)

Any ideas? Thanks