RULES
Rename
Description: Changes the name of a column or value.
Example: Renaming the column "product_id" to "id_produktu".
Combine
Description: Combines two or more values into one.
Example: Combining the columns "first_name" and "last_name" into "full_name".
Array to string
Description: Transforms an array of values into a single string.
Example: Transforming the list of categories ["electronics", "gadgets"] into "electronics, gadgets".
Add prefix
Description: Adds a specified prefix to each value in a column.
Example: Adding the prefix "SKU-" to each value in the "product_code" column, e.g., "12345" -> "SKU-12345".
Add suffix
Description: Adds a specified suffix to each value in a column.
Example: Adding the suffix "-PL" to each value in the "country_code" column, e.g., "PL" -> "PL-PL".
Replace single value
Description: Replaces one specific value with another value.
Example: Replacing the value "out_of_stock" with "unavailable" in the "status" column.
Replace multiple values
Description: Replaces multiple values with other values.
Example: Replacing "yes" and "no" with "true" and "false" in the "available" column.
Remove single value
Description: Removes a specific value from a column.
Example: Removing the value "N/A" from the "discount" column.
Remove multiple values
Description: Removes multiple specified values from a column.
Example: Removing the values "unknown", "N/A", and "null" from the "supplier" column.
Remove duplicates
Description: Removes repeated values.
Example: Removing duplicated product entries from the product catalog.
Leave empty
Description: Leaves cells empty.
Example: Leaving cells empty for missing product information.
Recapitalize
Description: Changes the letter case in text (e.g., to capital letters).
Example: Changing "laptop" to "Laptop" in the "product_name" column.
Recalculate
Description: Recalculates values according to new rules.
Example: Recalculating the gross price to net price in the "price" column.
Percentage Margin
Description: Calculates the percentage margin.
Example: Calculating the percentage margin from the "selling_price" and "cost_price" columns.
Percentage Markup
Description: Calculates the percentage markup.
Example: Calculating the percentage markup based on "cost_price" and "selling_price".
Round
Description: Rounds numbers to a specified number of decimal places.
Example: Rounding price values in the "price" column to two decimal places.
Extract from
Description: Extracts specific data from text.
Example: Extracting the postal code from the address in the "address" column.
Use lookup table
Description: Replaces values based on a lookup table.
Example: Using a lookup table to convert country codes to full names (e.g., "PL" to "Poland").
Segmentation
Description: Divides a data set into a specified number of equal groups. When using it, we must also select a field in Order by, i.e. by which field the division should be made, in Tiles name specify the names of individual intervals (there will be as many intervals as there are names specified) and in Order direction select - Descending or Ascending, depending on whether we want to divide and assign names descending or ascending.
Example: Dividing products into 3 groups (high, mid, low) based on the value in the ga4_item_netto_revenue field in descending order
Rank
Description: Assigns a rank to each row (each product) in the data set, taking into account the specified criterion given in the Order By field, and Order direction - Descending or Ascending, depending on whether we want to assign a rank descending or ascending
Example:
Ranking products descending based on the value in the gads_clicks field..
CONDITIONS
is equal to
Description: Checks if a value is equal to a specified value.
Example: Checking if the order status is "shipped".
is not equal to
Description: Checks if a value is not equal to a specified value.
Example: Checking if the product category is not "outlet".
contains
Description: Checks if a value contains a specified string.
Example: Checking if the product description contains the word "premium".
does not contain
Description: Checks if a value does not contain a specified string.
Example: Checking if the product review does not contain the word "bad".
is blank
Description: Checks if a value is blank.
Example: Checking if the "discount_code" field is blank.
is not blank
Description: Checks if a value is not blank.
Example: Checking if the "email" field is not blank.
starts with
Description: Checks if a value starts with a specified string.
Example: Checking if the product code starts with "ABC".
does not start with
Description: Checks if a value does not start with a specified string.
Example: Checking if the category name does not start with "old".
ends with
Description: Checks if a value ends with a specified string.
Example: Checking if an email address ends with "@gmail.com".
does not end with
Description: Checks if a value does not end with a specified string.
Example: Checking if a phone number does not end with "000".
is greater than
Description: Checks if a value is greater than a specified value.
Example: Checking if the product price is greater than 100 PLN.
is greater or equal to
Description: Checks if a value is greater than or equal to a specified value.
Example: Checking if the stock quantity is greater than or equal to 10 units.
is less than
Description: Checks if a value is less than a specified value.
Example: Checking if the delivery time is less than 5 days.
is less or equal to
Description: Checks if a value is less than or equal to a specified value.
Example: Checking if the number of returns is less than or equal to 2.
is between
Description: Checks if a value is between two specified values.
Example: Checking if the order date is between January 1 and December 31.
is not between
Description: Checks if a value is not between two specified values.
Example: Checking if the customer's age is not between 18 and 25 years.
is longer than
Description: Checks if the length of a value is greater than a specified length.
Example: Checking if the product description is longer than 100 characters.
is shorter than
Description: Checks if the length of a value is shorter than a specified length.
Example: Checking if the category name is shorter than 50 characters.
matches regex
Description: Checks if a value matches a specified regular expression.
Example: Checking if the phone number matches the pattern "^\d{3}-\d{3}-\d{4}$".
does not match regex
Description: Checks if a value does not match a specified regular expression.
Example: Checking if the postal code does not match the pattern "^\d{2}-\d{3}$".
is in list
Description: Checks if a value is on a specified list of values.
Example: Checking if the country code is on the list of EU codes.
is not in list
Description: Checks if a value is not on a specified list of values.
Example: Checking if the product category is not on the list of discontinued categories.
is in list (regexp)
Description: Checks if a value matches any regular expression from a list.
Example: Checking if an email address matches one of many regular expression patterns.
is not in list (regexp)
Description: Checks if a value does not match any regular expression from a list.
Example: Checking if a URL does not match any forbidden regular expression patterns.
Data filtering categories:
Some conditions can only be used for filtering numeric data, while others are only for textual data. Here's the breakdown:
Conditions for filtering textual data:
is equal to
is not equal to
contains
does not contain
is blank
is not blank
starts with
does not start with
ends with
does not end with
is longer than
is shorter than
matches regex
does not match regex
Conditions for filtering numeric data:
is equal to
is not equal to
is greater than
is greater or equal to
is less than
is less or equal to
is between
is not between
Some conditions, like "is equal to" and "is not equal to", can be used for both textual and numeric data.