Hey @amitavk, and welcome to the community! You are correct - transformers are basically read only, so you can’t set the values of other components / state and you can’t trigger other queries. You’ll need to use a JS Code query to do this.
I realize that this isn’t in our documentation, and apologies for that - adding it in right now!