cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

How to intersect/join multiple data tables ??

sbt
Amethyst

How to intersect/join multiple data tables ??

Hello ,

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)

Thanks

Sunay

3 REPLIES 3

Re: How to intersect/join multiple data tables ??

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.

Re: How to intersect/join multiple data tables ??

Carles,

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...???

Thanks

Sunay

Re: How to intersect/join multiple data tables ??

Don't think so.