Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Date Formatting

Hello all,

 

I have two tables which I want to combine.

Table A: Date_Key, ProductName, Sales

Table B: Date_Key, ProductName, Sales, CurrRates, CurrUnit

 

Upon combining the two tables, the result table returned two different date values.

Date_Key of both tables are in the "YYYYMMDD" format.

 

CONCATENATE(TableA)

LOAD
Date(DATE_KEY,'YYYYMMDD') AS DATE_KEY,
ProductName,
CurrUnit,
Sales
RESIDENT TableB;

DROP TABLE TableB;

It seem like one of my table captured the date field as TEXT while another table captured it as Date. Hence, when appending it result in two different format of values i.e., numeric date and YYYYMMDD.

Is there any way to standardize the type?

 

Tags (1)
2 Replies
Highlighted
Partner
Partner

Re: Date Formatting

Hi,

try to use 

Date#(DATE_KEY,'YYYYMMDD') AS DATE_KEY,

Highlighted
Partner
Partner

Re: Date Formatting

Hi,

Keep same format in both the table using Date#(), Date() and current format of the date.