Using the C1DataEngine, you can combine (join, blend) data from different data sources (tables) into a single table and analyze the combined data in FlexPivot. See Using C1DataEngine > Join to know in detail how to join multiple data sources.
Refer to the product sample DataJoin stored at the following location in your system to see how to build a join query dynamically based on our user selection of table and fields:
C:\...\Documents\ComponentOne Samples\WinForms\C1FlexPivot\CS or VB\DataJoin.
