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, ...
Forum Discussion
harikm007 - success w/ a Table widget, but not Pivot Table. Would it be possible in the latter?
Hey 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
We 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.
Hi 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.
