Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik community!
I got a data model defined, and I'm using two fields of dates:
- Date_1: 2010, 2011, 2012
- Date_2: 2012, 2013, 2014
I already tried to rename these two fields as one unique field through the script, but I created an circular reference (redundancy in the database).
How can I create, without modifying the script, one unique filter named Date_3 with the following values: 2010, 2011, 2012, 2013, 2014
Thanks a lot for your help!!
Regards,
Vincent
Vincet,
That is you need to analyse the data you are having man.
what if the values are different as
Date1=2010
Date2=2011
Else you can use join as
Table1:
Load
ID,
Date1 as Date_New
From----
Table2L:
P_ID
,Date2
from------
Join(Table1)
load
P_ID
,Date2 as Date_New
Drop Table Table2;
This will derieve a new column as Date_New as combination of two dates.