Querying data from influxdb and storing it into a measurement (table)
<p>I'm new to using InfluxDB and I have what I think is a relatively simple question that I cannot find the answer to. How can I query data from an existing measurement and write that data into another measurement, while storing the name of the measurement where that data came from?</p>
<p>For example, say I had the measurement</p>
<blockquote>
<p>name: temperature</p>
<p>time | external | internal |  machine</p>
<p>100  |     25    |      40      | unit42</p>
</blockquote>
<p>Is there a way I could grab some of that data and the measurement name and put it into a new table? Like this:</p>
<blockquote>
<p>name: aggregate table</p>
<p>time |  measurment |    external  |  machine</p>
<p>100 |   temperature  | 25          | unit42</p>
</blockquote>
<p>to be clear, I've looked up the into method, but I can't find a way to also store the name of the measurement
Thanks!</p>