You are viewing documentation about an older version (1.29.0). View latest version

snowflake.snowpark.functions.position

snowflake.snowpark.functions.position(expr1: Union[Column, str], expr2: Union[Column, str], start_pos: int = 1) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.29.0/snowpark-python/src/snowflake/snowpark/functions.py#L11135-L11155)

Searches for the first occurrence of the first argument in the second argument and, if successful, returns the position (1-based) of the first argument in the second argument.

Example:

>>> df = session.create_dataframe([['an', 'banana'], ['nan', 'banana']], schema=["expr1", "expr2"])
>>> df.select(position(df["expr1"], df["expr2"], 3).alias("position")).collect()
[Row(POSITION=4), Row(POSITION=3)]
Copy
Language: English