Script code

[Anonymous]

Hi

I want all the document numbers that have the status 'cleared'. And I also want the document numbers that have the status only 'open' but not 'Cleared'(For example, doc no 5105600105 should only give me one record, i.e. status 'cleared' and omit the record 'open' plus all the other records having the status only 'open'). I don't know what the code should be in the script to get this. Please help.

I am not sure if I am being able to articulate what I need. Please ask me if you have any doubt. Thanks!

[jonas_rezende]

Hi, Chandni Bhowmick.

Try:

LOAD

document,

creditor,

status

from [<nametable>]

where

status = 'Cleared Item'

Hope this helps!

[Anonymous]

Hi

I also want the document numbers that have the status only 'opened' but not 'cleared'.

[pokassov]

t1:

load

     document,

     creator,

     status

from .....qvd (qvd)

where status='Cleared Item';

concatenate (t1)

load

     document,

     creator,

     status

from .....qvd (qvd)

where status='Open Item'

and not exists (document);

[MK_QSL · Accepted solution]

Load

     document,

     creditor,

     status

From FileName

Where WildMatch(status,'*Cleared*');

Concatenate

Load

     document,

     creditor,

     status

From FileName

Where WildMatch(status,'*Open*') and not Exists(document);

[pratap6699]

Load document,creditor,status from source where status=cleareditem;