Example: Function Mapping with Multiple ANY IN TABLE Clauses - Advanced SQL Engine - Teradata Database

This function mapping definition includes two ANY IN TABLE clauses.

During function processing, the first two ON clauses that do not have correlation names correspond to the two ANY IN TABLE clauses.

CREATE FUNCTION MAPPING user_Attribution FOR attribution MAP JSON ( '{ "function_version": "1.0" }') USING ANY IN TABLE, ANY IN TABLE, conversion IN TABLE, excluding IN TABLE, optional IN TABLE, model1 IN TABLE, model2 IN TABLE, EventColumn, TimestampColumn, WindowSize;

These tables correspond to the two ANY IN TABLE clauses of the user_Attribution function mapping.

SELECT * FROM user_ATTRIBUTION( ON attribution_sample_table1 PARTITION BY user_id ORDER BY time_stamp ON attribution_sample_table2 PARTITION BY user_id ORDER BY time_stamp ON conversion_event_table AS conversion DIMENSION ON excluding_event_table AS excluding DIMENSION ON optional_event_table AS optional DIMENSION ON model1_table AS model1 DIMENSION ON model2_table AS model2 DIMENSION USING EVENT_COLUMN_NAME ('event') TIMESTAMP_COLUMN_NAME ('time_stamp') WINDOW('rows:10&seconds:20') ) as dt ORDER BY user_id, time_stamp;