Loading data from two databases with same table structures

[Qlik_Enthu]

Dear All,

I need to create a dashboard taking data from two different databases but with same table structures (including same column names).

I have blindly loaded the two tables and qualified the columns and unqualified one key column to establish connection between two tables. But now I could not figure out how to aggregate and visualise the data from two tables.

If someone come across similar situation, kindly throw some light

TIA!

[m_woolf]

Any reason not to concatenate the two tables?

If you need to know which table the data came from, you could do something like:

'Table1' as DataSource

[Qlik_Enthu]

I know which data comes from which table. however I need to display total orders placed in both databases in my visualizations.

[Anonymous]

If you concatenate the tables and add a column indicating which table the rows go to -

You can then easily do order counts by datasource using set analysis.

Something like count({<Datasource={'Table1'}>}OrderID) and count({<Datasource={'Table2'}>}OrderID)