Hello @jakinda1!
This should be possible. I would recommend looking at this thread in the forum. There is a youtube video at the bottom that goes over a similar situation.
The steps in the process would be:
- Grab table data
- Grab additional data from second data source
- Use a transformer/JS script to combine the data appropriately and save the finalized data
- Set the source of the table to be the result of the transformer/JS script
For the part of the question where you mention "second column on the same table" could you elaborate more on this with an example? Grabbing data from the table and changing it or renaming the column name can be done with a transformer as well!