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?
Hi bminehart ,
To concatenate columns in a table widget, try these steps:
const column1_index = 1;
const column2_index = 2;
widget.on('processresult', function(w, args){
args.result.$$rows.forEach(item => {
item[column1_index].text = `${item[column1_index].text} ${item[column2_index].text}`;
})
})
//Refer: https://www.binextlevel.com/post/hide-a-column-from-table-widget
widget.on('domready', function(se, ev){
$(`table tr > *:nth-child(${column2_index + 1})`, element).css('display', 'none')
const elementToObserve = $('table tbody', element)[0];
const observer = new MutationObserver(function(e) {
for(const m of e) {
if (m.type === 'childList') {
$.each(m.addedNodes, function(index, value){
$(value).find(`td:nth-child(${column2_index + 1})`).css('display', 'none')
})
}
}
})
observer.observe(elementToObserve, {subtree: true, childList: true});
})
3. Refresh the widget.
For more details on how to hide a column in the table widget, refer to this post: https://www.binextlevel.com/post/hide-a-column-from-table-widget
-Hari
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.
