Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
freceena
Contributor II
Contributor II

Mapping two dates in different tables to one table

I have two different tables in which date1 is in format of MM/DD/YYYY (11/23/2016) and date2 in format of YYYY-MM-DDT08:00:00Z (2016-11-2T08:00:00). I need to convert these date formats to MMM-YYYY and map value related to date2 to date1. Could anyone suggest a solution for this.

Labels (2)
2 Replies
Kushal_Chawda

@freceena  try below

date(Date#(Date1,'MM/DD/YYYY'),'MMM-YYYY') as Date1

date(floor(date#(subfield(date2,'T',1),'YYYY-MM-DD')),'MMM-YYYY') as Date2

freceena
Contributor II
Contributor II
Author

Thank you for reply. I need to map the value related to Date1 to the table having Date2. For example, (Date1, value1) should be mapped in such a way that after mapping we should get (Date2,value1)