I have a scenario where i need to join multiple data tables.
Intersect allows me to join only 2 tables.
Is there a way to join multiple tables apart from intersect.( all tables are thingworx datatables)
No. If you have a complex data model, maybe better that you leverage a Relational Database with JDBC connector extension, instead of using ThingWorx DataTables.
I have configuration max 5-8 tables where the datarow would not go more than 50 rows.
If i use intersect multiple times , will there be a performance hit...???
Don't think so.
Retrieving data ...