yep, this is possible using SimpleDateFormat library:

groovyconsole.appspot.com/script/5715999101812736

I got the same question but I am struggling because I am not sure where to state the script and how to set the Variable.
How does my code would have to look like?
Would it be like this:
The Variable I would like to set is called $Date

import java.text.SimpleDateFormat;
SimpleDateFormat outputFormat=new SimpleDateFormat("ww");
Date today=new Date();

$Date==println outputFormat.format(today);

Thanky for your help in advance

Kind regards

code to set in a groovy job:

Hi Laloune,

Could you please elaborate a little bit more? Once I have the groovy job set, how do I update the value of my variable $Date? I need to use this variable to extract the data for the Current Date only, from a sql table of nearly 5mil rows transaction data.

If not variable, how do I use this 'Date' value in my query for filtering out my extract data?

Thanks and Regards,
Kiran

Hi Kiran,

you can use the variable as a constant. For instance in you sql query you would have the following:

SELECT
*
FROM
myBIGTable
WHERE
theDate = '${Date}'

with a groovy job you set the variable and execute the load using API.executeLoad('yourload');

no?

Here is what I did:

1. Set up a variable by name Date - referred to as ${Date}

2. Set up a groovy job as follows:



3. Created an extract with the query as you had mentioned.

I did not create the load yet, but, when I preview the extract, I dont see the result I want. It does not seem to be filtering as per the date. Where am I going wrong?

Regards,
Kiran

Hi Kiran,

this variable stuff works this way:

- you define a variable and a default value for it (click on the variable then fill the field)
- in the groovy job the command API.setProperty('xxx'); will overwrite the default value and execute the load/job using the newly set property

you can display the result of the extract from the job and using the set property. For that append your groovy job using the following:



more info here in the groovyjob sample

hope this helps

I am sorry Laloune, guess I am going wrong somewhere.. Would you be able to send me a sample xml file (ETL) with the functionality in?

Thanks,
Kiran

you can find the functionality in the sample xml file under /tomcat/webapps/etlserver/data/samples/sampleGroovyJob.xml

Got it, and it works beautifully..

Thanks Laloune.