Can a table have a column from another collection

[tferguson]

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

[benbarry]

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)

[tferguson]

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

[benbarry]

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

In your case {{ businessName.value }}

[tferguson]

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

[benbarry]

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

[benbarry]

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