Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have table below mentioned.
DATE | BRAND | PRODUCT | RATE |
6/1/2016 | ABC | SMPO | 5000 |
6/1/2016 | DTC | APLE | 4300 |
6/1/2016 | VGS | CART | 2000 |
6/1/2016 | CTG | BEGTS | 7000 |
6/1/2016 | OTS | NTB | 9000 |
6/2/2016 | ABC | LPS | 3000 |
6/2/2016 | DTC | ORG | 7500 |
6/2/2016 | VGS | ONIN | 3000 |
6/2/2016 | CTG | SHTS | 9500 |
6/2/2016 | OTS | PEN | 1500 |
6/3/2016 | ABC | SMPO | 3500 |
6/3/2016 | VGS | TNTA | 5500 |
6/3/2016 | DTC | STANE | 4500 |
6/3/2016 | OTS | NTB | 7000 |
6/4/2016 | ABC | HRDH | 6500 |
6/4/2016 | DTC | ORG | 4000 |
6/4/2016 | CTG | PSNJ | 8000 |
6/4/2016 | OTS | NUS | 3700 |
6/5/2016 | ABC | LPS | 5600 |
6/5/2016 | VGS | BHA | 2200 |
In this,
I have some records on 6/1/2016. the same record to be there in the following dates. The price is as mentioned. If the same record not in the another date, then the Price values to be replaced before record value.
Thanks.
Hi Silambarasan,
I have got your desired output.
Please find the attachment.
Thanks
Hi Silambarasan,
I have got your desired output.
Please find the attachment.
Thanks
Can you please provide your required result , that will help.
Thanks for the reply guys.
I got the expected output.