Skip to main content
13-Aquamarine
February 10, 2025
Solved

Merging Two QueryPropertyHistories From Different Things Together

  • February 10, 2025
  • 2 replies
  • 614 views

Hi all,

 

I am trying to merge two queryPropertyHistories from 2 different things together and am struggling to figure it out. I have two queries from two different things which wouldn't have a set data shape or property values (user selected). The end goal is to combine two queries and output them into a line chart widget. 

 

For example, these two images I would want combined into a single infotable used for a line chart. So basically just add the second infotable to the end of the first infotable then chart it (data doesn't need to be perfectly clean in table form). The property names are never the same as it is user input for the queries.

 

Any recommendations on how to merge these?

 

JK_10744682_0-1739216982571.png

JK_10744682_1-1739216988991.png

 

 

Best answer by Velkumar

Hi @JK_10744682 

 

Please check this article - CS237109 - How to Merge InfoTables in ThingWorx

 

/VR

2 replies

Velkumar19-TanzaniteAnswer
19-Tanzanite
February 11, 2025

Hi @JK_10744682 

 

Please check this article - CS237109 - How to Merge InfoTables in ThingWorx

 

/VR

14-Alexandrite
February 11, 2025

As the datashapes are same, you can use union in infotable functions