concat strings at the dashboard layer?
In a table or pivot table widget I want to concatenate strings contained in two separate data model columns. Example: col1 contains "Abraham" and col2 contains "Lincoln". I want to concatenate them, along with a space to display "Abraham Lincoln" in another column
I know there is not a widget level function to do this. Would this be possible in a widget script? And if so - any idea how?
bminehart
Posted 1 year ago·Last reply 1 year ago
6 comments
bminehart
OP1 year agoharikm007 - success w/ a Table widget, but not Pivot Table. Would it be possible in the latter?
Assaf Hanina
·1 year agoHey bminehart ,
In addition to the solution provided for the Table widget, you might consider performing the concatenation directly at the data source level. This can be achieved by merging columns into a single table (e.g., using a Join or Lookup) and creating a new column for the full name.
This approach allows for easy drag-and-drop functionality across various widget types, minimizing the need for additional scripts.
Best regards
bminehart
OP1 year agoWe already do this for some combinations of columns, but because we've embedded Sisense in an app that is intended to be adaptable/universal for a variety of customers and use cases, there are too many variations of string concatentations for us to build into the data layer. We really need it at the user/Dashboard layer.
DRay
·1 year agoHi bminehart,
If this isn't something that Sisense can do out-of-the-box, can you submit it in the Product Feedback Forum?
Thank you.
bminehart
OP1 year agoThanks harikm007 -- we'll give this a go and take a look at the blog posting.