cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Combining Two tag Queries

Former Member
0 Likes
238

I am trying to combine 2 tag queries with 5 tags in each one into one table to put in a web page. What is the easiest way to do this.

I am attempting to combine them with the xmii logic editor. I can get one tag query in to an xml saver just fine but I am having trouble appending the 2nd tag query as a second column to the first tag query.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Likes

Ken:

This is a good use of the Union, Join, and/or Interpolator action(s).

Does each query result have the exact same # of rows and exact same timestamp(s)?

Also, if you're just sending them to an iChart, a Union action will fork fine. If you are trying to merge them for a grid, it is slightly trickier.

Describe the data and the desired UI look in more detail and we can help ya out.

- Rick

Former Member
0 Likes

If I understand you correctly, you have two queries that return timestamped values for two sets of five tags. Assuming the timestamps are the same you could use the XML Joiner Action. If the times are not the same, then the XML Time Interpolator is just what you need.

Former Member
0 Likes

They are both current tags so time is somewhat irrelavent. I would just like to match up 2 columns with two different tag queries. There are 5 rows each.

Thanks for the idea about interpolate though. I will probably use it on other applications.

Former Member
0 Likes

Hi Ken,

Are you saying that the end result should be a document (table) with two columns and 10 rows - kind of one query result on top of each other?

Former Member
0 Likes

No not that. I want a column with 5 rows and along side of it I want the other tag query to look like a second column with 5 rows.

Is there a way to post a picture so I can show what I am trying to acheive?

It is probably very simple but I struggle with it.

Former Member
0 Likes

Ok, I understand now. You can't post images, but if you can, post the xml output of the two tag queries.