Is it possible to merge data from two different data sources in Dashbuilder data providers?

Issue

• Is it possible to merge data from two different datasources in Dashbuilder data providers?

• For example:

  • Create an external datasource.
  • Create a new data provider.
  • If I select external datasource from the datasource dropdown, able to query only external tables.
  • If I select local datasource from the datasource dropdown, able to query only local tables.