replace one date to all date

[vipin_mishra479]

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

Order	level	mov_type	Date
22526	0	101	3/6/2012
22526	1	261	9/9/2013
22526	2	261	9/11/2013

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

Order	level	mov_type	Date
22526	0	101	3/6/2012
22526	1	261	3/6/2012
22526	2	261	3/6/2012

here i attached the qvw

[nagaiank · Accepted solution]

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.