Skip to main content
S
sbt15-Moonstone
15-Moonstone
November 8, 2017
Question

How to intersect/join multiple data tables ??

  • November 8, 2017
  • 1 reply
  • 2266 views

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

1 reply

C
CarlesColl1-Visitor
1-Visitor
November 8, 2017

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.

S
sbt15-MoonstoneAuthor
15-Moonstone
November 8, 2017

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

C
CarlesColl1-Visitor
1-Visitor
November 8, 2017

Don't think so.

Terms & ConditionsAccessibility statement