Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
In my script editor I want to load data only in a specific date range ie from 01/01/2010 onwards
how do I write this?
Thanks
This is my script
LOAD IncidentID,
Region,
Site,
DateRaised,
Year(DateRaised) as Year,
Month(DateRaised) as Month,
ReportedBy,
NonConformanceArea,
NonConformanceAreaCategory,
Description,
Priority,
CloseOut,
CompletionDate
in script editor write your load like below
load
column1,
column2
.....
from path where DateRaised>='01/01/2010'
in script editor write your load like below
load
column1,
column2
.....
from path where DateRaised>='01/01/2010'
if you have some trouble with the comparison with the date as a string,
you can replace the condition in the previous post to:
from path where DateRaised>= makedate(2010)
or
from path where year( DateRaised) >=2010
Hope this helps,
Erich
Thanks
It works!