Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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;
...
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