Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a coloumn in a oracle table as data.
I need to have the column into the qlikview seperated as day , month , year , hour , minute
Can i have this loaded seperated in the load ?
HI
Try like this
Load
day(DateField) as Day,
month(DateField) as month,
Year(DateField) as Year,
Hour(DateField) as Hour,
Minute(DateField) as Minute,
*;
Select * from tablename;
Use preceding load, it helps
Hope it helps