Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use Alt() function
LOAD
date1
alt(date2,date1) as date2
from yourexcelfile.xls
Use Alt() function
LOAD
date1
alt(date2,date1) as date2
from yourexcelfile.xls
Hi,
You can also try,
Load Date1,
If(Len(Trim(Date2))=0, Date1, Date2) as Date2
From Excel;
Please close the thread by marking the correct answer if you got what you wanted.
Try like this
Load
Date1,
If(Len(Trim(Date2))=0, Date1, Date2) as Date2
From Table;
if(Date2, Date2, Date1)