Merging Two QueryPropertyHistories From Different Things Together

[JK_10744682]

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?

[Velkumar · Accepted solution]

Hi @JK_10744682 

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

/VR

[Bikash_Panda]

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