12-21-2014 06:00 PM
I need to substitute blank values in column "January Estimate" with the value from "6m Avg" every time On Promotion is "N" and January estimate is "." But for On Promotion "Y" it should retain the same value in the estimate column
|ProdCode||LongDescription||QtyOnHand||On Promotion||January Estimate||6m Avg|
How do I do it?
12-21-2014 06:10 PM
You need to show example data that captures both conditions and, for clarity, what you want the resulting file to look like. I, personally, would also like to see you propose code to solve the problem.
12-21-2014 07:56 PM
Hi, please try the below code , However i agree with Art , if you provide more details then you will get the more appropriate response.
i just tried with a simple if then statement. Hope this helps.
if OnPromotion='N' and JanuaryEstimate eq . then JanuaryEstimate=_6mAvg;