All

[raadwiptec]

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

[sunny_talwar]

May be this:

LOAD *

FROM ....

Where not WildMatch(INVOICE, '*LM') or INVOICE = 'KLWEDLM';

[german24]

Hi,

try this, e.g.

Table:

LOAD

     InvoiceName

FROM.......

WHRE Right(InvoiceName,2) <> 'LM' or InvoiceName LIKE '*KLWEDLM'

;

Best regards,

German

[Anil_Babu_Samineni]

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';

[sasiparupudi1]

Load *

Resident YourTable

Where not WildMatch(INVOICE, '*LM') or WildMatch(INVOICE,'*KLWEDLM');

[muthukumar77]

Load *

Resident YourTable

Where WildMatch(INVOICE, '*LM') or WildMatch(INVOICE,'*KLWEDLM');