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.

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 a boolean 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