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

mmg1984 — Thu, 23 Feb 2023 23:49:13 GMT

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

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

Digvijay_Singh — Fri, 24 Feb 2023 02:44:53 GMT

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
];

topic Re: Create a filter with values to check if exist in a column in App Development

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

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