Forum Discussion
Merging and Plotting Multiple DataSets with Varying Time-step Increments
Hi, jstein91694
According to your description, I think you need to rename the four columns like date,time,timestamp,record. You need to make the column names and data types of the three tables exactly the same, and then append them.
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Each of the queries has a Date and a Time column. Like I mentioned, one query may have formats of time that are like this: 3:50:02pm and it increments by 2 seconds, whereas another query has the format of time like this: 3:00:00pm and it increments by 1 minute. When I create my line plot and choose an axis, no matter which DateTime column I used, I am only ever to plot the data which corresponds to the query of the DateTime column I am using.
I would like to create a relationship between all queries, and be able to plot all of the queries' data on the same lineplot. (For queries that increment at 2 minute increments, I can average the data for each minute, if I can still plot the data on a DateTime axis that increments each minute)
jstein91694 , can these be appened?
Can you share a small sample data and sample output in table format?
I tried appending and that did not work. Below are screenshots showing the format of a couple of the datasets.
Note how each Time row for each dataset increments by a different amount, so the time's only match up every so often for the datasets.
Did you ever get this resolved. I'm having a similar challenge where I have one data set that has increments of days, sometimes multiple datapoints per day. The other is basically every month. I'd like to plot both on the same graph and just connect a line between data points for the monthly while the daily can be on the X-axis.
