Example of CONCAT_VIEW , REPLACE_VIEW, SUBSTRING_VIEW,

[huangbin chen]

Hi Excerpt,

I saw some functions (CONCAT_VIEW , REPLACE_VIEW, SUBSTRING_VIEW) here: https://docs.stiltsoft.com/display/TFAC/General+syntax+and+SQL+functions+available

I can see "CONCAT_VIEW_AGGR" example here: https://docs.stiltsoft.com/display/TFAC/Custom+Transformation+-+use+cases+with+advanced+SQL+queries

But I cannot find examples of CONCAT_VIEW , REPLACE_VIEW, SUBSTRING_VIEW.

May I know where I can find some examples to use these functions.

Thanks.

[Katerina Rudkovskaya _Stiltsoft_]

Hi @Huangbin Chen,

The _VIEW ending means that functions preserve the initial HTML format (the original format of the cell contents), for example, links. Otherwise, they work as functions without the _VIEW ending that transform everything to plain text.

So, to check how the function works in general, go to the first part of the table, find the correspondent function (for example, CONCAT), click on the link and create some queries yourself.

If you are stuck with the query, please refer to our support. Give us a screenshot of your original table, the query and describe what you need to achieve.