Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to get get all data from source but want to skip few. For ex
Load all invoices data but not INVOICE name ending with 'LM' and only one data ending with 'KLWEDLM'
Invoice name | ,~Number | Amount
May be this:
LOAD *
FROM ....
Where not WildMatch(INVOICE, '*LM') or INVOICE = 'KLWEDLM';
Hi,
try this, e.g.
Table:
LOAD
InvoiceName
FROM.......
WHRE Right(InvoiceName,2) <> 'LM' or InvoiceName LIKE '*KLWEDLM'
;
Best regards,
German
Load all invoices data but not INVOICE name ending with 'LM' and only one data ending with 'KLWEDLM'
LOAD *
FROM ....
Where not WildMatch(INVOICE, '*LM') or INVOICE = '*KLWEDLM';
Load *
Resident YourTable
Where not WildMatch(INVOICE, '*LM') or WildMatch(INVOICE,'*KLWEDLM');
Load *
Resident YourTable
Where WildMatch(INVOICE, '*LM') or WildMatch(INVOICE,'*KLWEDLM');