1. Home
  2. Latest Release Docs
  3. Guides
  4. Concepts
    1. Aggregate filter
    2. Alias
    3. Apache Avro™
    4. Apache Kafka™
    5. Applied filter
    6. Base table
    7. Bookmark
    8. Business schema
    9. Business schema view
    10. Business schema view column
    11. Business schema view formula column
    12. Column
    13. Connector
    14. Dashboard filter
    15. Dashboard folder
    16. Dashboard runtime filter
    17. Data agent
    18. Data alert
    19. Data destination
    20. Data purge
    21. Data retention
    22. Date system variable
    23. Distinct filter
    24. Dynamic field
    25. Expression
    26. External data source
    27. External session variable
    28. Filter expression
    29. Filter expression session variable
    30. Filter option
    31. Formula column
    32. Formula expression
    33. Full load
    34. Global variable
    35. Incorta Analyzer Table
    36. Incorta Analyzer Table column
    37. Incorta Analyzer Table formula column
    38. Incorta Analyzer View
    39. Incorta Analyzer View formula column
    40. Incorta Spark SQL View
    41. Incorta SQL Table
    42. Individual filter
    43. Insight filter
    44. Internal query expression
    45. Internal session variable
    46. Join
    47. Join condition
    48. Join condition column
    49. Join filter
    50. Join filter column
    51. Level-based measure
    52. Load filter
    53. Local data file
    54. Local data folder
    55. Materialized View
    56. Materialized View column
    57. Materialized View formula column
    58. Measure filter
    59. Miscellaneous system variable
    60. Multi-source table
    61. Physical schema
    62. Physical schema table
    63. Physical schema table column
    64. Physical schema table formula column
    65. Physical schema table runtime security filter
    66. PostgreSQL (Incorta SQL) View
    67. Presentation variable
    68. Prompt
    69. Query system variable
    70. Runtime business view
    71. Runtime business view formula column
    72. Runtime security filter
    73. Schema evolution
    74. Session variable
    75. Shared Storage
    76. Upgrade Readiness
    77. Variable
    78. Visualization
  5. Tools
  6. References
  7. Integrations
  8. Data applications
  9. Release Notes
  10. Incorta Premium

Concepts → Join Filter Column

About a join filter column

A join filter column is the filterable column in a join filter expression.

While a join condition defines the relationship between the entity objects in the join and specifies the criteria for matching records in the Parent entity, a join filter further restricts the records to retrieve from the Parent entity object. Both the join condition and join filter exists in the ON clause of the SQL statement.

The join filter column, along with the join filter operator and value, constructs the expression that restricts the rows to retrieve from the Parent entity object in the join. As such, a join filter column references a column in the Parent entity object (that is, the entity object in the right side of the join). You specify a join filter in a physical schema using the Join Editor.

Supported columns for a join filter column

The following are the types of columns that you can reference in a join filter:

  • Physical_Schema.Table.Column
  • Physical_Schema.Table.Formula_Column
  • Physical_Schema.Incorta_Analyzer_Table.Column
  • Physical_Schema.Incorta_Analyzer_Table.Formula_Column
  • Physical_Schema.Materialized_View.Column
  • Physical_Schema.Materialized_View.Formula_Column
  • Physical_Schema.Alias.Column
  • Physical_Schema.Alias.Formula_Column
  • Physical_Schema.Incorta_SQL_Table.Column (including computed columns)
Note: Supporting joins using cross-table formulas

Before 2024.7.x, Incorta has not supported using cross-table formula columns as a join filter column. Starting 2024.7.x, Incorta supports one level of joins using cross-table formulas. The Loader executes Post-load calculations using a plan generated based on the dependencies between calculations while the Analytics perform calculations in stages: first in-table formulas, then joins, and finally cross-table formulas. After evaluating the cross-table formulas, a second stage for join calculations is performed.

Important

In the case of a cross-schema join, you need to own both physical schemas or, at least, have Edit access rights to the physical schema of the Child object and View access rights to the physical schema of the Parent object.

Supported data types for a join filter column

The following table shows the supported and recommended data types for columns that you can reference in a join filter from the Parent entity object:

Data typeSupportedRecommended
Boolean (in the case of using formula columns that return a boolean value)✓✓
Date✓✓
Double✗
Integer✓✓
Long✓✓
Null✗
String✓✗
Text✓✗
Timestamp✓✗
Important

It is not recommended to use a text or string column for the join filter column as string comparisons can be slow for large data volumes.