topic Re: Combining 10 Infotable and create one infotable in ThingWorx Developers

Combining 10 Infotable and create one infotable

AG_10811269 — Sat, 07 Oct 2023 11:52:32 GMT

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?

Re: Combining 10 Infotable and create one infotable

Sathishkumar_C — Sat, 07 Oct 2023 13:04:01 GMT

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.

Re: Combining 10 Infotable and create one infotable

AG_10811269 — Thu, 19 Oct 2023 18:56:42 GMT

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.

Re: Combining 10 Infotable and create one infotable

Sathishkumar_C — Mon, 23 Oct 2023 04:42:02 GMT

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