how to set a variable during reloading data

[#1]

hi

i create a variable (v_max_date) . the purpose of this is to hold the max date of the current table,

since i did an incremental load , i need this variable for the WHERE close.

i was thinking that every time the table is finish loading to Resident the table like this:

(

load

MaxString (Date) as maxdate

Resident Failures; 

)

Now i want to make a variable to hold this maxdate for next time using.

how do i do it ?

thank you

[deepakk]

hi Sharon,

try this out.

load

MaxString (Date) as maxdate

Resident Failures;

Let v_max_date = peek('maxdate');

I hope this helps.

Deepak

[#3]

Thank you

It works perfectly !!!!

[deepakk]

hi sharon,

doo verify the post , it helps other to know that the issue has been resolved.

Deepak

[#5]

hi

i am new here how do i do that?

[deepakk]

hi,

On every post , you will see  two button , one for correct answer and another one helpful.

If you get a correct answer, click that button. But sometimes you get some helpful answer too in that case click the other one.

[#7]

thank you