Conditional IF

[#1]

Hi

I have 2 columns,date and rate. When date is=today() I want that respective rate column. I want to do this in the script. I have attached a sample excel

Thanks for your help

[sunny_talwar]

I don't see a rate field? Have you attached the right Excel file? Not sure I am able to relate your Excel to the description. please elaborate

[#3]

HI Sunny

I think I attached the wrong file. I am sending the right file now. For date=todays date I want to fetch that respective rate column in my script part

Thanks

[avinashelite]

try like this:

if(date(date_field,'DD-MM-YYYY')=date(today(),'DD-MM-YYYY'),rate) as new_rate

or

if(num(date_field)=num(today()),rate) as new_rate

[Digvijay_Singh]

May be try smthg like this -

Temp:

LOAD Sno,

     Name,

     Direction,

     CURR,

     VALUE,

     ENDDATE

FROM

test.xlsx

(ooxml, embedded labels, table is Sheet1);

Final:

Load VALUE

Resident Temp

Where ENDDATE=today();

Drop table Temp;

[avinashelite]

didn't find the rate column in the attachment could you check your attachment ??

[sunny_talwar]

Still don't see the Excel being changed. No rate column still

[#8]

Thank you, this seems to have worked. Will try again at work on Monday and update back. Really appreciate it