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)
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