From a data readability and governance perspective, enforcing values in place of NULL improves efficiency - again  based on downstream reporting needs. This would avoids unnecessary string comparisons and simplifies...

Snehalatha - You can achieve similar functionality in SNOWFLAKE using a combination of SUBSTR, CONCAT, and REPLACE functions like what Thomas Franz already mentioned. Thank you

The context of the project was to build a report that would need us to concatenate values from various unique rows into a single string, with delimiters (like commas) and...

Thomas Franz - With all due respect, every project and scenario is unique and we found this function to work the best based on our project context. You may refer...

• This reply was modified 8 months ago by Ganesh Gopal Masti Jayaram.