topic Re: How do i use where to select more than 700 data from 2000 in QlikView

How do i use where to select more than 700 data from 2000

Wed, 13 Jan 2016 09:31:45 GMT

I have something like this code segments below. I have selected numbers to pick when i run it only maximum of 321 account numbers came out and i need the whole of 700 account numbers. what do i do?

Load*,

[Account number]

FROM

C:\Book.xlsx

(qvd)

where wildmatch([Account number]) ,

, '*8880080*', '*8880088*', '*8880088*','*8880080*','*8880088*'

,'*8880088*','*8880800*','*8880808*','*8880808*','*8880880*','*8880888*','*8880888*','*8880880*'

,'*8880888*','*8880888*','*8880830*','*8880838*','*8880838*','*8880840*','*8880848*','*8880848*'

,'*8880850*','*8880858*','*8880858*','*8880860*','*8880868*','*8880868*','*8880870*','*8880878*'

,'*8880878*','*8880880*','*8880888*','*8880888*','*8880890*','*8880898*','*8880898*','*8880800*'

,'*8880808*','*8880808*','*8880880*','*8880888*','*8880888*','*8880880*','*8880888*'*8880888*'

,'*8880830*','*8880838*','*8880838*','*8880840*','*8880848*','*8880848*','*8880850*','*8880858*'

,'*8880858*','*8880860*','*8880868*''*8880868*','*8880870*','*8880878*','*8880878*','*8880880*'

,'*8880888*','*8880890*','*8880898*','*8880898*','*8880300*','*8880308*','*8880308*'*8880380*','*8880388*','*8880388*','*8880380*','*8880388*'

,'*8880388*','*8880330*','*8880338*','*8880338','*8880340*''*8880348*','*8880348*','*8880350*'

,'*8880358*','*8880358*,'*8880360*','*8880368*,'*8880368*','*8880370*,'*8880378*','*8880378*

,'*8880380*','*8880388*,'*8880388*','*8880390*,'*8880398*','*8880398*,'*8880400*','*8880408*

,'*8880408*','*8880480*,'*8880488*','*8880488*','*8880480*','*8880488*,'*8880488*','*8880430*'

,'*8880438*','*8880438*','*8880440*','*8880448*','*8880448*','*8880450*','*8880458*','*8880458*'

,'*8880470*','*8880478*','*8880478*','*8880480*','*8880488*','*8880488*','*8880490*','*8880498*'

);

Re: How do i use where to select more than 700 data from 2000

Anonymous — Wed, 13 Jan 2016 09:41:38 GMT

Could you share the list of your account number??

Can we do something like?

load

From Table where AccountNumber like '*8880*';

Re: How do i use where to select more than 700 data from 2000

Wed, 13 Jan 2016 10:00:06 GMT

No, No, I have other Account numbers starting with same '*8880*'

Re: How do i use where to select more than 700 data from 2000

Anonymous — Wed, 13 Jan 2016 10:02:19 GMT

which account you do not want to load??

any logic behind them?

Re: How do i use where to select more than 700 data from 2000

Wed, 13 Jan 2016 10:12:08 GMT

No, these are few numbers i wanna pick from set of other numbers. clear?

Re: How do i use where to select more than 700 data from 2000

Anonymous — Wed, 13 Jan 2016 10:18:41 GMT

okay, then you can try like this?

where match(AccountNumber,'1','2','3','4') and so on

Re: How do i use where to select more than 700 data from 2000

tamilarasu — Wed, 13 Jan 2016 10:32:50 GMT

Try something like below,

AccNum:
LOAD * INLINE [
    CustId
    *10*
];

Tmp:
NoConcatenate
Load concat(Distinct CustId,',') as CustId
Resident AccNum;

Let vVar = Peek('CustId',0,'Tmp');
Drop Table Tmp, AccNum;

Data:
LOAD *
FROM
Book1.xlsx
(ooxml, embedded labels, table is Sheet1) where WildMatch([CustId a],$(vVar));

Add your account numbers in inline table or you can use excel load (store all account numbers in excel).