|
Don't use a composite column. Instead use template mode in SR, put the "huge switch function" in the template box, and store the result in the genre column. Save the SR for easier access in the future.
You can make this easier if you put the huge switch into a user-defined template function, but that might not be practical because it requires writing the switch in python.
|