Hi there!
Hmm, this isn't necessarily a use case that I've worked on before, but I think you could accomplish this with a custom column.
I'm including an app export of where I've tried this out. It is using dummy data, so it would have to be modified a bit for a real use case.
If you type a different value into the Name column & then click out of the cell, you should see Column 4 change. I've left the subCat column that comes from the table data there even though it isn't dynamic
This is the code for the custom column
{{ [
{id: 2,
"name": "ads",
"subCat": ["adwords", "facebook", "google_ads"]
},{id: 3,
"name": "another",
"subCat": ["other", "another one"]
},
{id: 1,
"name": "amazon",
"subCat": ["amazon_internet"]
}
].filter(x=> self.changesetArray.filter(x=>x.id ===currentSourceRow.id).length>0? x.name=== self.changesetArray.filter(x=>x.id ===currentSourceRow.id)[0].name: x.name === currentSourceRow.name)[0].subCat }}