Live data model connected to Snowflake. We have some long text columns containing carriage returns and tabs. If we display these values in a table or pivot table in Sisense, the text is missing the carriage returns and tabs. Is it possible to have text displayed with the carriage returns and tabs properly?
Thank you, that's interesting. I'm not able to find any resources that discuss this, so if you like I can work on finding a technical resource to work with you directly on this. Would you like me to get the ball rolling on that?
|
We can use regex function to convert the line breaks \n to <br> as part of data transformation strategy. In the below example I am using this function as custom import query which ideally should be done directly on snowflake as part of their ETL process or views. By using this function I was able to preview the result directly in the pivot.
|
.png){kind=link}
.png){kind=link}