How to use load script to remove wrong data entry ?

[paulyeo11]

Hi All

I have a raw data file , due to operator enter wrong year 2020 , now it affect my QV report. as i am not able to display all SOURCE compute by sales.

Does any one here know how to remove the particular data year = 2020 to 2010 ?

Paul

[paulyeo11]

Hi Rud

it work , thank you .

Paul

[kkkumar82]

Hi Paul,

Is your problem not to load dates which have 2020 or to replace it with another year

[paulyeo11]

Hi Kumar

My issue operator data entry enter wrong date , the date affect my report , and i want to use script to change the year from 2020 to 2010.

Paul

[paulyeo11]

Hi Kushal

Do you mean i can do some thing like below :-

Binary "C:\Users\QV\Dropbox\QV file to PY Dropbox\000_qvd_v11.qvw";

where year(DateField)<= year(today());

So those year more then current year will change to current year it is ?

Paul

[paulyeo11]

Hi Rudolf

thank you very much for your script . I have tested it work fine. many thank.

Paul