Need some help creating a function
I am on a journey to learn SnowFlake, but now I am really stuck on something. I have looked everywhere, and tried all solutions. But I still do something wrong.
Function in a query does not return more than one row when reading from another record in a table
I have a basic function that when given one number as input can return two different values in the form of a table. I would like this function to read the values contained in a column of another table, but I am not succeeding at this.
Snowflake function unable to return multiple rows
I am trying to create a function in Snowflake that returns to me the rows matching a condition, but it only works when there is only one row matching the condition.