Can a table have a column from another collection

Is it possable to add a new column in a table that pulls data from different database collection?

Yes, you can combine data from multiple queries with a transformer and then pass that value to the table.

Working example app:
combineDataSources.json (12.8 KB)

thank you for your reply, how do i apply a transformer to a table?

Just pass the value the transformer outputs to the the table's data input:

In your case {{ businessName.value }}

i am unable to get it to ingest the data into the table, my query1 and query2 are different collections in mongodb

Shouldn't matter. Here is an example where I setup to pull from two of my own mongo collections.

You could also do something like this, although, you'd have less control over it.