Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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);
Hi, Chandni Bhowmick.
Try:
LOAD
document,
creditor,
status
from [<nametable>]
where
status = 'Cleared Item'
Hope this helps!
Hi
I also want the document numbers that have the status only 'opened' but not 'cleared'.
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);
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);
Load document,creditor,status from source where status=cleareditem;