topic Date in QlikView

Date

Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I have two date columns in excel data like this ...

Date1 Data2

10/mar/1999 10/mar/1999

16/june/2000

25/oct/2001 27/oct/2001

05/feb/2002 15/feb/2002

06/Nov/1999

then we ever the empty in Date2 then filled with date1 dates.

output like this:-

Date1 Data2

10/mar/1999 10/mar/1999

16/june/2000 16/june/2000

25/oct/2001 27/oct/2001

05/feb/2002 15/feb/2002

06/Nov/1999 06/Nov/1999

Clever_Anjos — Sat, 26 Mar 2016 12:13:06 GMT

Use Alt() function

LOAD

date1

alt(date2,date1) as date2

from yourexcelfile.xls

tamilarasu — Sat, 26 Mar 2016 16:02:31 GMT

Hi,

You can also try,

Load Date1,

If(Len(Trim(Date2))=0, Date1, Date2) as Date2

From Excel;

sunny_talwar — Sun, 27 Mar 2016 22:09:18 GMT

Please close the thread by marking the correct answer if you got what you wanted.

avinashelite — Mon, 28 Mar 2016 05:58:05 GMT

Try like this

Load

Date1,

If(Len(Trim(Date2))=0, Date1, Date2) as Date2

From Table;

tyagishaila — Mon, 28 Mar 2016 06:54:32 GMT

if(Date2, Date2, Date1)