Forum Discussion
Appending different columns
Hello, I have three queries with body sensor values, which contains columns Time, Pir(body movement) and body(body appearance) which are measured every 10 mins, and all of the queries have same colum...
Hi Anonymous
Could you give an example output table after appending these table?
I don't understand which row in table "ventilation " should connect to each row of the body sensor1, body sensor2, body sensor3 tables.
Best Regards
Maggie
Hi, v-juanli-msftOne of my questions is how I can append the body Sensor data with the Ventilation date. I want to use time and airflow from the ventilation table, to visualize how much Airflow it sends when someone is in the room and how many persons(based on the body sensors we can know how many people are there when the body value shows 1)
Is there a way to append those tables when they don't have similar columns?