I have a requirement in order management.I have some SP orders which are booked in advance but not yet confirmed.So for this orders we have orderentereddate and orderconfirmdate.This orders will flow into my open,closed and cancel data.Lets say an order has chnaged from SP to Closed order directly for this order i need to use the Orderconfirmdate instead of orderentereddate.
For this I am loading the SP orders (lets say some 30 orders)data first and then I am loading my closed orders date(10000) in to two sets like 1.where data exists in SP orders.2 does not exists in SP orders.
But this way i am not able to achieve my requerment.
Can some one suggest me if i am wrong any where.Kindly let me know if you need more info.
Sorry, I can't follow you. Don't really know your requirement, how you tried to achieve your requirement (test data, script code) and why this doesn't work for you (what you get, what you expect instead).
Please try creating some sample lines of data and try to create your expected output from that.
