Filter
This is most powerful and complex preparation option where you can filter incoming data with multiple rules:
- 1.Incoming data is compared by a compare method with defined input values
- 2.That filtered value is transformed to the defined output value
- 3.and results in a defined result method.
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" |
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"] |
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
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 modified 4yr ago