Carriage returns in list column

Question & Answer
1

I’m connecting Snowflake as a datasource. One of the columns in the SF DS contains a list. In SF the list contents look like this…
[
obj1,
obj2
]
When QS pulls this data in (I’m using a direct connection to SF and not SPICE) I’m getting carriage returns in my results…
[\n ‘obj1’, \n ‘obj2’]
Could I please get some tips on how to remove the carriage returns. I’ll need access to the data in these lists. Thank you

2

I would suggest doing all of this in SQL. Quicksight doesn’t have array functions and is pretty limited with JSON extraction.

3

OK thank you. Yes, I’m going to try to clean this up in Snowflake before it gets to QuickSight.

1 Like
4

Thank you @garnold . Once your problem will get resolve, please share the solution steps so that it will help other members in the community.

Regards - Sanjeeb

5

In the end I’m working with my DB and we will alter the data in Snowflake before it comes into QuickSight.

1 Like