Combining 10 Infotable and create one infotable

3 replies
1964 views
Translate All

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?

1_Infotable-Merge-Service.txt

Coding

S

Sathishkumar_C

17-Peridot

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.

Translate

A

AG_10811269

Author

1-Visitor

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.