Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
My date format is few of 'Text format'and few of 'Number format' .
Like : 2014-03-01
2014-03-01
2011-07-01... Etc this are text formate...
40728
40729
40730
40731
40732... Etc this are Number format....
Could you help on this..
Advance Thanks
Munna
Check this in a text object by selecting any one value randomly
=Date(Date#(DateField,'YYY-DD-MM'),'DD/MM/YYYY')
If it works, then use as is in the load script by changing with your DateField.
Upadte :
Use this will work as you expected.
=alt(date#( DateField ,'YYYY/MM/DD' ),
date(DateField,'DD/MM/YYYY'))
Hi
Try like this
In script,
Alt(Date(Date#(DateField,'YYYY-MM-DD'),'DD/MM/YYYY') , Date(DateField,'DD/MM/YYYY')) AS DateField
Hope that helps
Hi,
Try like this in load script
Data:
LOAD
*,
Alt(Date(Date#(DateDimensionName,'YYYY-MM-DD')) , Date(DateDimensionName)) AS DateField
FROM DataSource;
Hope this helps you.
Regards,
Jagan.
See the attached file
Date(num(alt(DAtefield)),'YYYY-MM-DD') as Date
as already suggested use alt function when you have different format in the same field
you can find a detailed explanation at pag 8 of this doc
Load
DATE(Alt(Date#(DATE,'YYYY-MM-DD'),
DATE)) as DATE Inline
[
DATE
2014-03-01
2014-03-01
2011-07-01
40728
40729
40730
40731
40732
];