Filter
This is most powerful and complex preparation option where you can filter incoming data with multiple rules:
Incoming data is compared by a compare method with defined input values
That filtered value is transformed to the defined output value
and results in a defined result method.
Settings
Compare
Method which is applied when comparing defined input values with incoming data.
Method | Description |
equal | Value1 === Value2 i.e.: "test" & "test" |
includes | Wildcard search: Value1 is included in Value2 i.e.: "test" & "myteststring" |
startsWith | Value1 starts with Value2 i.e.: "test" & "teststring" |
endsWith | Value1ends with Value2 i.e. "test" & "stringtest" |
Result
Method which is applied to generate the final result.
Method | Input | Output |
Exclude | ["Test","Test2"] | ["OutputValue"] |
Add | ["Test","Test2"] | ["Test","Test2","OutputValue"] |
Replace | ["Test","Test2"] | ["Test","OutputValue"] |
Inputs to Output
You can define multiple input/output combinations which should be filtered.
Input can have multiple values
Which result in the output value as a
string
or aboolean
value
Use-cases
Exclude brands from name
Let's say you have locations which represents supermarkets and you want to add a filter to your locator where users can filter by a supermarket chain or brand.
Element: Brand
We're adding a new element called brand
Element type: Select
Because we want to filter for that particular value we define brand as type select.
Compare: includes
Brand names would be extracted from the input if they are included in the incoming data.
Result: exclude
We want to define the amount of
Inputs/Output: Every row represents a
Last updated