Discontinue selling the products that has not been selling enough for the past 2 years

[kaushiknsolanki]

Hi,

You can simply create a days difference between OrderDate and Today, and use simple condition to identify the products which should be stopped.

For example.

Data:

Load *,Today() - OrderDate as Diff from XYZ;

Final:

Load *,If(Diff>365,'Discontinue','Continue') as Flag Resident Data;

Regards,

Kaushik Solanki