Reply
Member
Posts: 50
Registered: ‎05-29-2018
Accepted Solution

Multiple tables for a single dataset

Hello,

 

I'm trying to create a data set from one of my data sources. I would like to import multiple tables from a database of SQL Server, but I am not able to do so. Do you know if it's possible? I don't want just a single table.

 

Thank you

 

Nick


Accepted Solutions
Highlighted
Established Member
Posts: 147
Registered: ‎06-20-2017

Re: Multiple tables for a single dataset

Hi Nick - a data soruce is a connection to a single database, a data set is only one table. To use multiple tables, you either need to join then the SQL query (to create a single table) or use multiple datasets.

View solution in original post


All Replies
Highlighted
Established Member
Posts: 147
Registered: ‎06-20-2017

Re: Multiple tables for a single dataset

Hi Nick - a data soruce is a connection to a single database, a data set is only one table. To use multiple tables, you either need to join then the SQL query (to create a single table) or use multiple datasets.