topic Re: Mark the Policy No in QlikView

Mark the Policy No

upaliwije — Sun, 21 Sep 2014 13:09:51 GMT

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

Re: Mark the Policy No

nagaiank — Sun, 21 Sep 2014 13:25:02 GMT

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)

Re: Mark the Policy No

upaliwije — Sun, 21 Sep 2014 14:16:43 GMT

THANKS