Color Particles by Related Dataset

Hi

I have two data sets.
The first consists of point data where each point also has an attribute called “region”. Basically, it looks like this:

id points region
0 1 1 1 0
1 2 2 2 0
2 3 3 3 1
3 4 4 4 1

The second describes these regions, their extents, and some string attribute per region. So there is cell data that describes (in this case two) cells of type Voxel and point data that defines these Voxels. These Voxels map 1:1 to the regions of the first data set. For each Voxel I then have a string attribute called “tag” like this:

Cell ID Cell Type tag
0 Voxel sunny
1 Voxel rainy

Over the course of the simulation, these tags can change for every cell and particles can move from one cell to another.
I can easily visualize the particles and color them by the region-id and visualize the cells and color them by their tag. However, what I would like to do is visualize the particles and color them by the tag of their corresponding region!
Can I do this with filters within ParaView? Or do I have to manually create vtk files that contain the merged dataset like this:

id points region tag
0 1 1 1 0 sunny
1 2 2 2 0 sunny
2 3 3 3 1 rainy
3 4 4 4 1 rainy