Hey I tried this in Redshift and seems to work fine with a Multi/Sub object material as d4rk3lf says, and using Material ID operator in tyFlow.
Here's a video of it working. https://streamable.com/rjjuya
I tried the same set up using RSMultiMap too, but the IDs don't seem to work (unless baked into the mesh using MatID operator), which I think removes Instancing functionality
Here's a video of it working. https://streamable.com/rjjuya
I tried the same set up using RSMultiMap too, but the IDs don't seem to work (unless baked into the mesh using MatID operator), which I think removes Instancing functionality