Skip to content

The easy-to-use open source Business Intelligence and Embedded Analytics tool that lets everyone work with data :bar_chart:

12.3 KB
Raw Blame
name: String Functions
entity_id: HeLFZSVb4Jm25p4tWfVP9
creator_id: [email protected]
display: table
collection_id: cOlQuErIeS0ExAmPlE2x1
parameters: []
parameter_mappings: []
dataset_query:
  database: Sample Database
  stages:
  - expressions:
    - - concat
      - lib/expression-name: Title and Category
      - - field
        - {}
        - - Sample Database
          - PUBLIC
          - PRODUCTS
          - TITLE
      - ' ('
      - - field
        - {}
        - - Sample Database
          - PUBLIC
          - PRODUCTS
          - CATEGORY
      - )
    - - substring
      - lib/expression-name: First 10 Chars
      - - field
        - {}
        - - Sample Database
          - PUBLIC
          - PRODUCTS
          - TITLE
      - 1
      - 10
    - - replace
      - lib/expression-name: Cleaned Vendor
      - - field
        - {}
        - - Sample Database
          - PUBLIC
          - PRODUCTS
          - VENDOR
      - Inc.
      - Incorporated
    - - regex-match-first
      - lib/expression-name: EAN Prefix
      - - field
        - {}
        - - Sample Database
          - PUBLIC
          - PRODUCTS
          - EAN
      - ^\d{3}
    - - trim
      - lib/expression-name: Trimmed Title
      - - field
        - {}
        - - Sample Database
          - PUBLIC
          - PRODUCTS
          - TITLE
    - - ltrim
      - lib/expression-name: Left Trimmed
      - - field
        - {}
        - - Sample Database
          - PUBLIC
          - PRODUCTS
          - TITLE
    - - rtrim
      - lib/expression-name: Right Trimmed
      - - field
        - {}
        - - Sample Database
          - PUBLIC
          - PRODUCTS
          - TITLE
    - - upper
      - lib/expression-name: Upper Category
      - - field
        - {}
        - - Sample Database
          - PUBLIC
          - PRODUCTS
          - CATEGORY
    - - lower
      - lib/expression-name: Lower Title
      - - field
        - {}
        - - Sample Database
          - PUBLIC
          - PRODUCTS
          - TITLE
    - - length
      - lib/expression-name: Title Length
      - - field
        - {}
        - - Sample Database
          - PUBLIC
          - PRODUCTS
          - TITLE
    - - substring
      - lib/expression-name: Title From 5th Char
      - - field
        - {}
        - - Sample Database
          - PUBLIC
          - PRODUCTS
          - TITLE
      - 5
    limit: 10
    source-table:
    - Sample Database
    - PUBLIC
    - PRODUCTS
    lib/type: mbql.stage/mbql
  lib/type: mbql/query
result_metadata:
- active: true
  base_type: type/BigInteger
  database_type: BIGINT
  display_name: ID
  effective_type: type/BigInteger
  field_ref:
  - field
  - - Sample Database
    - PUBLIC
    - PRODUCTS
    - ID
  - null
  id:
  - Sample Database
  - PUBLIC
  - PRODUCTS
  - ID
  name: ID
  position: 0
  semantic_type: type/PK
  source: fields
  table_id:
  - Sample Database
  - PUBLIC
  - PRODUCTS
  visibility_type: normal
  lib/deduplicated-name: ID
  lib/desired-column-alias: ID
  lib/original-display-name: ID
  lib/original-name: ID
  lib/source: source/table-defaults
  lib/source-column-alias: ID
  qp/implicit-field?: true
- active: true
  base_type: type/Text
  database_type: CHARACTER VARYING
  display_name: Ean
  effective_type: type/Text
  field_ref:
  - field
  - - Sample Database
    - PUBLIC
    - PRODUCTS
    - EAN
  - null
  id:
  - Sample Database
  - PUBLIC
  - PRODUCTS
  - EAN
  name: EAN
  position: 1
  source: fields
  table_id:
  - Sample Database
  - PUBLIC
  - PRODUCTS
  visibility_type: normal
  lib/deduplicated-name: EAN
  lib/desired-column-alias: EAN
  lib/original-display-name: Ean
  lib/original-name: EAN
  lib/source: source/table-defaults
  lib/source-column-alias: EAN
  qp/implicit-field?: true
- active: true
  base_type: type/Text
  database_type: CHARACTER VARYING
  display_name: Title
  effective_type: type/Text
  field_ref:
  - field
  - - Sample Database
    - PUBLIC
    - PRODUCTS
    - TITLE
  - null
  id:
  - Sample Database
  - PUBLIC
  - PRODUCTS
  - TITLE
  name: TITLE
  position: 2
  semantic_type: type/Title
  source: fields
  table_id:
  - Sample Database
  - PUBLIC
  - PRODUCTS
  visibility_type: normal
  lib/deduplicated-name: TITLE
  lib/desired-column-alias: TITLE
  lib/original-display-name: Title
  lib/original-name: TITLE
  lib/source: source/table-defaults
  lib/source-column-alias: TITLE
  qp/implicit-field?: true
- active: true
  base_type: type/Text
  database_type: CHARACTER VARYING
  display_name: Category
  effective_type: type/Text
  field_ref:
  - field
  - - Sample Database
    - PUBLIC
    - PRODUCTS
    - CATEGORY
  - null
  id:
  - Sample Database
  - PUBLIC
  - PRODUCTS
  - CATEGORY
  name: CATEGORY
  position: 3
  semantic_type: type/Category
  source: fields
  table_id:
  - Sample Database
  - PUBLIC
  - PRODUCTS
  visibility_type: normal
  lib/deduplicated-name: CATEGORY
  lib/desired-column-alias: CATEGORY
  lib/original-display-name: Category
  lib/original-name: CATEGORY
  lib/source: source/table-defaults
  lib/source-column-alias: CATEGORY
  qp/implicit-field?: true
- active: true
  base_type: type/Text
  database_type: CHARACTER VARYING
  display_name: Vendor
  effective_type: type/Text
  field_ref:
  - field
  - - Sample Database
    - PUBLIC
    - PRODUCTS
    - VENDOR
  - null
  id:
  - Sample Database
  - PUBLIC
  - PRODUCTS
  - VENDOR
  name: VENDOR
  position: 4
  semantic_type: type/Company
  source: fields
  table_id:
  - Sample Database
  - PUBLIC
  - PRODUCTS
  visibility_type: normal
  lib/deduplicated-name: VENDOR
  lib/desired-column-alias: VENDOR
  lib/original-display-name: Vendor
  lib/original-name: VENDOR
  lib/source: source/table-defaults
  lib/source-column-alias: VENDOR
  qp/implicit-field?: true
- active: true
  base_type: type/Float
  database_type: DOUBLE PRECISION
  display_name: Price
  effective_type: type/Float
  field_ref:
  - field
  - - Sample Database
    - PUBLIC
    - PRODUCTS
    - PRICE
  - null
  id:
  - Sample Database
  - PUBLIC
  - PRODUCTS
  - PRICE
  name: PRICE
  position: 5
  source: fields
  table_id:
  - Sample Database
  - PUBLIC
  - PRODUCTS
  visibility_type: normal
  lib/deduplicated-name: PRICE
  lib/desired-column-alias: PRICE
  lib/original-display-name: Price
  lib/original-name: PRICE
  lib/source: source/table-defaults
  lib/source-column-alias: PRICE
  qp/implicit-field?: true
- active: true
  base_type: type/Float
  database_type: DOUBLE PRECISION
  display_name: Rating
  effective_type: type/Float
  field_ref:
  - field
  - - Sample Database
    - PUBLIC
    - PRODUCTS
    - RATING
  - null
  id:
  - Sample Database
  - PUBLIC
  - PRODUCTS
  - RATING
  name: RATING
  position: 6
  semantic_type: type/Score
  source: fields
  table_id:
  - Sample Database
  - PUBLIC
  - PRODUCTS
  visibility_type: normal
  lib/deduplicated-name: RATING
  lib/desired-column-alias: RATING
  lib/original-display-name: Rating
  lib/original-name: RATING
  lib/source: source/table-defaults
  lib/source-column-alias: RATING
  qp/implicit-field?: true
- active: true
  base_type: type/DateTimeWithLocalTZ
  database_type: TIMESTAMP WITH TIME ZONE
  display_name: Created At
  effective_type: type/DateTimeWithLocalTZ
  field_ref:
  - field
  - - Sample Database
    - PUBLIC
    - PRODUCTS
    - CREATED_AT
  - null
  id:
  - Sample Database
  - PUBLIC
  - PRODUCTS
  - CREATED_AT
  name: CREATED_AT
  position: 7
  semantic_type: type/CreationTimestamp
  source: fields
  table_id:
  - Sample Database
  - PUBLIC
  - PRODUCTS
  visibility_type: normal
  lib/deduplicated-name: CREATED_AT
  lib/desired-column-alias: CREATED_AT
  lib/original-display-name: Created At
  lib/original-name: CREATED_AT
  lib/source: source/table-defaults
  lib/source-column-alias: CREATED_AT
  qp/implicit-field?: true
- base_type: type/Text
  display_name: Title and Category
  effective_type: type/Text
  field_ref:
  - expression
  - Title and Category
  name: Title and Category
  source: fields
  lib/deduplicated-name: Title and Category
  lib/desired-column-alias: Title and Category
  lib/expression-name: Title and Category
  lib/original-name: Title and Category
  lib/source: source/expressions
  lib/source-column-alias: Title and Category
  qp/implicit-field?: true
- base_type: type/Text
  display_name: First 10 Chars
  effective_type: type/Text
  field_ref:
  - expression
  - First 10 Chars
  name: First 10 Chars
  source: fields
  lib/deduplicated-name: First 10 Chars
  lib/desired-column-alias: First 10 Chars
  lib/expression-name: First 10 Chars
  lib/original-name: First 10 Chars
  lib/source: source/expressions
  lib/source-column-alias: First 10 Chars
  qp/implicit-field?: true
- base_type: type/Text
  display_name: Cleaned Vendor
  effective_type: type/Text
  field_ref:
  - expression
  - Cleaned Vendor
  name: Cleaned Vendor
  source: fields
  lib/deduplicated-name: Cleaned Vendor
  lib/desired-column-alias: Cleaned Vendor
  lib/expression-name: Cleaned Vendor
  lib/original-name: Cleaned Vendor
  lib/source: source/expressions
  lib/source-column-alias: Cleaned Vendor
  qp/implicit-field?: true
- base_type: type/Text
  display_name: EAN Prefix
  effective_type: type/Text
  field_ref:
  - expression
  - EAN Prefix
  name: EAN Prefix
  source: fields
  lib/deduplicated-name: EAN Prefix
  lib/desired-column-alias: EAN Prefix
  lib/expression-name: EAN Prefix
  lib/original-name: EAN Prefix
  lib/source: source/expressions
  lib/source-column-alias: EAN Prefix
  qp/implicit-field?: true
- base_type: type/Text
  display_name: Trimmed Title
  effective_type: type/Text
  field_ref:
  - expression
  - Trimmed Title
  name: Trimmed Title
  source: fields
  lib/deduplicated-name: Trimmed Title
  lib/desired-column-alias: Trimmed Title
  lib/expression-name: Trimmed Title
  lib/original-name: Trimmed Title
  lib/source: source/expressions
  lib/source-column-alias: Trimmed Title
  qp/implicit-field?: true
- base_type: type/Text
  display_name: Left Trimmed
  effective_type: type/Text
  field_ref:
  - expression
  - Left Trimmed
  name: Left Trimmed
  source: fields
  lib/deduplicated-name: Left Trimmed
  lib/desired-column-alias: Left Trimmed
  lib/expression-name: Left Trimmed
  lib/original-name: Left Trimmed
  lib/source: source/expressions
  lib/source-column-alias: Left Trimmed
  qp/implicit-field?: true
- base_type: type/Text
  display_name: Right Trimmed
  effective_type: type/Text
  field_ref:
  - expression
  - Right Trimmed
  name: Right Trimmed
  source: fields
  lib/deduplicated-name: Right Trimmed
  lib/desired-column-alias: Right Trimmed
  lib/expression-name: Right Trimmed
  lib/original-name: Right Trimmed
  lib/source: source/expressions
  lib/source-column-alias: Right Trimmed
  qp/implicit-field?: true
- base_type: type/Text
  display_name: Upper Category
  effective_type: type/Text
  field_ref:
  - expression
  - Upper Category
  name: Upper Category
  source: fields
  lib/deduplicated-name: Upper Category
  lib/desired-column-alias: Upper Category
  lib/expression-name: Upper Category
  lib/original-name: Upper Category
  lib/source: source/expressions
  lib/source-column-alias: Upper Category
  qp/implicit-field?: true
- base_type: type/Text
  display_name: Lower Title
  effective_type: type/Text
  field_ref:
  - expression
  - Lower Title
  name: Lower Title
  source: fields
  lib/deduplicated-name: Lower Title
  lib/desired-column-alias: Lower Title
  lib/expression-name: Lower Title
  lib/original-name: Lower Title
  lib/source: source/expressions
  lib/source-column-alias: Lower Title
  qp/implicit-field?: true
- base_type: type/Integer
  display_name: Title Length
  effective_type: type/Integer
  field_ref:
  - expression
  - Title Length
  name: Title Length
  source: fields
  lib/deduplicated-name: Title Length
  lib/desired-column-alias: Title Length
  lib/expression-name: Title Length
  lib/original-name: Title Length
  lib/source: source/expressions
  lib/source-column-alias: Title Length
  qp/implicit-field?: true
- base_type: type/Text
  display_name: Title From 5th Char
  effective_type: type/Text
  field_ref:
  - expression
  - Title From 5th Char
  name: Title From 5th Char
  source: fields
  lib/deduplicated-name: Title From 5th Char
  lib/desired-column-alias: Title From 5th Char
  lib/expression-name: Title From 5th Char
  lib/original-name: Title From 5th Char
  lib/source: source/expressions
  lib/source-column-alias: Title From 5th Char
  qp/implicit-field?: true
visualization_settings: {}
card_schema: 24
serdes/meta:
- model: Card
metabase_version: v1.57.1-SNAPSHOT (14ff27d)
type: question