replace one date to all date

vipin_mishra479 — Sat, 01 Jun 2013 14:12:48 GMT

Hi all,

i have a 4 field

Order,level,mov_type,date

and my question is that

i want to replace 101 mov_type date to all 261 mov_type with respect to order and level

eg-

this is my table

I want to replace 101 mov_typ date to 261 or 262 all date

here i attached the qvw

Re: replace one date to all date

nagaiank — Sat, 01 Jun 2013 15:14:42 GMT

Add the script

Temp:

LOAD Order, Date as Date2 Resident YourData where mov_type = 101;

Left Join (YourData) LOAD * Resident Temp;

DROP Table Temp;

The application is attached.