Create a filter with values to check if exist in a column

[mmg1984]

Hello,

I have the following problem, I'll try to explain it with easy data, I have 2 tables:

Filtering table:

White 

Black 

Blue 

Data Table:

Black;White 

White 

Blue;White 

Black 

What I want to do is to put Filtering table in a filter and Data Table in a table so I can select one colour in the filtering and that will filter the Data Table by any row that contains that colour, example if I select Black the result would be:

Data table:

Black;White 

Black 

Any idea how can I do it?

Thanks in advance 

[mmg1984]

I have the following problem, I'll try to explain it with easy data, I have 2 tables:

Filtering table:

White 

Black 

Blue 

Data Table:

Black;White 

White 

Blue;White 

Black 

What I want to do is to put Filtering table in a filter and Data Table in a table so I can select one colour in the filtering and that will filter the Data Table by any row that contains that colour, example if I select Black the result would be:

Data table:

Black;White 

Black 

Any idea how can I do it?

Thanks in advance 

[Digvijay_Singh · Accepted solution]

I think subfield with two parameter can help in this situation - 

Filter:
Load * inline [
Color
White
Black
Blue
];

Data:

Load *, subfield(DataColor,';') as Color inline [
DataColor
Black;White
White
Blue;White
Black
];