What is the best way to populate a Power table with a regular SELECT Query and "Join" in Tag values as columns?
We have a Production Run table named "packschedule", we want to run the following Select Query and include a live Tag, named {[default]Can Filler/Can Count}.
SELECT * FROM Packschedule
WHERE t_stamp Between "2024-12-12 00:00:00" AND 2024-12-12 23:59:59"
How would we add or Join the Tag to this query?
It can be done, but why not just have a label bound to the tag and off to the side of the table? Must it really be in the table too?
Thank you dkhayes117, That was my suggestion too.
My customer would like it all incorporated into one table.
Plus, i simplified the query for this forum. The actual one will be combing two tables and 6 tags.
Any idea how I can put the two sources (Table data and tag) into one power table?
You have to bind the query to a custom property, and script the creation of the combined table dataset to assign to the table's data property.
(Or use dataset manipulation/construction expression functions from my Integration Toolkit.)
