Join report for two tables

[Sriramachandra1]

I have two tables suupplier and archiving supplier both dont have any relation client want to combine both tables in a single report can anyone suggest idea to combine tables in databaseview

Supplier table u_duplicate_supplier

Archving supplier u_arch_duplicate_supplier

[Ankur Bawiskar]

Hi,

Unless there is something in common or relation between them you cannot combine them using database view.

Once you identify that you can create database view joining both the tables and then show that as report.

Regards
Ankur

[Arav]

Hi,

Consider checking the steps below and see if it helps. I am assuming the second table you have noted is an archival table of table 1.

a. Create a bar chart report on table 1 (I have used "incident" in my example) and add appropriate filters

b. From the report, by clicking the expand icon at the top right, add a dataset that points to table 2 ("ar_incident" in my example) and add appropriate filters

c. Once done, data from both tables will show up similar to the one below (note that the data is grouped by state in the example below).

e. Asses this option for any performance implications before trying it.

Thanks,

Arav

[Arav]

Hi Sriramachandra,

Wanted to check if the suggestion above helped. Please keep us posted.

Thanks,

Arav