Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.