Combining 10 Infotable and create one infotable

[AG_10811269]

I am taking logged data from 10 properties of 10 things. I am using the "QueryNumberPropertyHistory" service to fetch logged property data for things. The output infotable contains "id, timestamp, value" fields. I tried to combine two infotables by using the "Left Join" query. But when I tried to use the same query to combine three infotables, it wouldn't work.

Can anyone please help me achieve the required output?

[Sathishkumar_C]

• Try with union option https://www.ptc.com/en/support/article/CS237109. This is one of the good choice.
• If the output, you are going to use in chart... Then you try with "Multiple data sources" in chart.

[AG_10811269]

I have one dropdown to select multiple inputs like machines (Machine 1, Machine 2, Machine 3...). In another dropdown, I want to select one property (ex.  machine status).
Once I select the machine or machines and the property, then I want to display histographical data for the properties of all selected machines from the dropdown in the line chart widget.

The union function combines data from two tables, as shown in the below image.

My requirement is quite different. I want separate columns for each machine, as shown in the below image. The FULL JOIN shows me data in the below format, but this is not accurate.

I have also replicated the same code mentioned by you in the previous email, but it is adding entries one below the other.

[Sathishkumar_C]

if your getting data from value stream...

• you can get 2 inputs (thing name and proprty name) from drop down button.
• write a custom service to get data 
• rename the field names to field1, field2, field3.... and fieldN
• map into the line chart