Merge dimensions into 1

[deepak_km9886]

i have following structure

All have different Values,

records count also have different column name, so there isnt any association in data model,

I want To merge all the dates with common name Date and bring those associated records count in to the table/pivot Table,

How to acheive this in qlik sense?

[swuehl]

Maybe rename your fields to common names?

edit:

Like

LOAD

     Date_1 as Date,

     RecCount1 as Reccount,

     'Table1' as Table

From TABLE1;

LOAD

     Date_2 as Date,

     RecCount2 as Reccount,

     'Table2' as Table

From TABLE2;

...

[deepak_km9886]

Record count is a calculated field here,and it differs for each of the 5 entity i have,

i want all the dates to  be merged into one common name date and values of record count accordingly, record count should be zero if the entity has no values,something like this