Managing current and archival data in the different tabs with common filter

[DMP]

Requirement to show up current and archival data in two different tabs but all the tabs having left side common filter for program and other key filters. Since i do have different table for current and archival , I populate the data based on the attributes present in the table.

tab_current.qvd

[progam]

[att2]

[att3_stat]

[snapid] - * current having stats only for one snap id

tab_archive.qvd

[program_arc]

[att2_arc]

[att3_stat_arc]

[snapid_arc] - * archival having stats for olders snapids

When user picks up the filter for program in the left side filter in one tab, it has to be applied all the tabs including archival tab. since these are 2 different table, its not having any relationship. How can i achieve make a relationship with archival and current table. This is an existing application. Currently there are 5 tabs which show up current data up and running and 6th tab we are creating now to show up only archival data.

[kfoudhaily]

you need to concatenate you data in one single table

final_table:
load
'current' as source_data
[progam],
[att2],
[att3_stat],
[snapid],
from tab_current.qvd;

concatenate(final_table)
'archive' as source_data
[program_arc] as [progam],
[att2_arc] as [att2],
[att3_stat_arc] as [att3_stat],
[snapid_arc] as [snapid],
from tab_current.qvd;

please don't forget to accept response and like if it's ok for you.

regards,