Creating a Filter Pane for Dual-Field Search

[YanivZi]

I aim to integrate the search functionality for two specific fields within the same row. The dataset, illustrated in the current table, necessitates the establishment of a filter pane, possibly implemented as a master item. This filter should selectively display rows where either F1 or F2 (or both) contain the value "2."

Person	F1	F2
John	1	2
Jane	1	2
Mike	2	1
Sony	3	1
Lore	2	2

The desired outcome in the table results should reflect this criterion, as illustrated in the current table display.

Person	F1	F2
John	1	2
Jane	1	2
Mike	2	1
Lore	2	2

[Or]

If I understand the requirement, this seems to be a simple if() scenario?

If(F1=2 or F2=2,'Only2') as FilterField

[YanivZi]

I meant that the filter pane is already populated with the content of F1 and F2 and has values 1,2,3 but when i select "2" from the list then the table will give me the value from F1 or F2 or both

[Or]

In that case, you would need to load both F1 and F2 into the same field.

Load * From YourTable;

Load Person, F1 as FilterField From YourTable;

Concatenate

Load Person, F2 as FilterField From YourTable;