Hello, everybody! I've a question about "options no_values" clause. Could you help me? I have 2 very large tables with several thousands of rows and only 2 columns each. First column is 'datetime' and the second is some parameter.
Example of my table - https://docs.google.com/spreadsheets/d/14KjSFWQPdNLChT76xIc8fYm5NSn8OpARoLONdmauf-c/edit?usp=sharing In the table A datetime had been recorded each 5 minutes, and in table B – each 20 minutes. I want to merge these tables into one with datetime every 1 hour. Something like this: Datetime (YYYY-MM-DD HH:00:00) AVG(ParameterA) AVG(ParameterB) So what’s am I doing? 1. Getting data from table A with query: Select MIN(A), AVG(C), Year(A), Month(A)+1, Day(A), Hour(A) group by Year(A), Month(A)+1, Day(A), Hour(A) Order by MIN(A) Format MIN(A) 'YYYY.MM.DD HH:00:00' 2. It's give me exactly that I need! Every row have been grouped by hour and everything seems to be ok. 3. Than I’m getting data from Table B with the pretty much the same query. 4. And after all I’m trying to merge data by VLOOKUP (hour-by-hour). 5. And here comes the problem! Although my datatime columns looks very nice and clean (because of format) it has different Min(A) values, because data was written in different minutes of hour. So I have cells in Tables A&B looks like “2017.06.15 01:00:00”, but if I’m checking the values of these cells, it is “2017.06.15 01:04:00” and “2017.06.15 01:09:00” for tables A and B. And because the values is different, VLOOKUP is not working. ( 6. I’ve found information about “options no_values” clause, but it is not changing anything in my case… What I’m doing wrong? Thank you! -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/fe58cd60-7bbb-4411-bd1d-4f2fbfc340ef%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
