I faced a problem which I'd like to solve w/o any programming. And looking for a software to do this.
I have a dataset, for example: (brand-id, brand-name, product-class-name;)
0, Audi, economy business premium; 1, Rolls Royce, luxury; 2, Seat, economy; 3, Tesla, business premium;
And I'd like to automatically process this dataset, resulting in creating an additional table to classify parameters in column 3, like: (product-class-id, product-class-name, brand-id;)
0, economy, 0 2; 1, business, 0 3; 2, premium, 0 3; 3, luxury, 1;
Is there any database managing tool with features like this one? (preferably Mac)