topic Re: All in QlikView

All

raadwiptec — Wed, 25 Nov 2020 16:16:04 GMT

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 — Tue, 07 Mar 2017 13:48:50 GMT

May be this:

LOAD *

FROM ....

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

german24 — Tue, 07 Mar 2017 13:59:33 GMT

Hi,

try this, e.g.

Table:

LOAD

InvoiceName

FROM.......

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

;

Best regards,

German

Anil_Babu_Samineni — Tue, 07 Mar 2017 14:03:53 GMT

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 — Wed, 08 Mar 2017 08:41:00 GMT

Load *

Resident YourTable

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

muthukumar77 — Wed, 08 Mar 2017 09:48:22 GMT

Load *

Resident YourTable

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