Mark the Policy No

[upaliwije]

LOAD,

POLICY_NO

CLASS,

AMOUNT

FROM C:\POLICY.QVD;

(QVD)

Say I have 1000 policies in the above load. In that 1000 policies there about 10 policies which I want to mark as 'UNPAID' and I know the numbers as well. How Can I edit the script to suit it

[nagaiank · Accepted solution]

Add the policy numbers, as you know them, as UNPAID in the load using preceding load:

LOAD *, If(Match(POLICY_NO,policy1,policy2,...,policy10),'UNPAID') as STATUS;

LOAD,

POLICY_NO

CLASS,

AMOUNT

FROM C:\POLICY.QVD;

(QVD)

[upaliwije]

THANKS