topic Do not load all data in QlikView

Do not load all data

Wed, 28 Dec 2011 12:18:27 GMT

Hi all

I have a small problem. I am loading some data and there I have articles with different number of figures (5-7-8-9). I will only load data for the articles that has a length of 7 of more.

How do I do that?

EXTERNALIDENTIFIER is my article and I have tried some different solutions without luck

LOAD

//   ID,
//    VERSION,    EXTERNALIDENTIFIER,
    if(len(EXTERNALIDENTIFIER>=7),EXTERNALIDENTIFIER) as Article,

//    HOSTIDENTIFIER,
//    DESCRIPTION,
//    DELETEDBYHOST,
//    LASTORDER,
//    SHELFLIFE,

best regards

Bjarne

Do not load all data

rbecher — Wed, 28 Dec 2011 12:44:15 GMT

Hi Bjarne,

just use a Where Clause:

where len(EXTERNALIDENTIFIER)>=7

- Ralf

Do not load all data

Wed, 28 Dec 2011 12:56:58 GMT

Hi Ralf

I have tried this

LOAD // ID,
// VERSION, EXTERNALIDENTIFIER as Article,,

"MERCHANDISECATEGORY_ID" as ArticleGroupID;

SQL SELECT *
FROM MSMATERIAL
where len(EXTERNALIDENTIFIER)>=7;

But it will not "eat" where len(EXTERNALIDENTIFIER)>=7; Any further help?

Do not load all data

rbecher — Wed, 28 Dec 2011 13:20:38 GMT

Which database vendor do you have? Could be length( )..

You could also use a where clause in the LOAD part:

LOAD // ID,
// VERSION, EXTERNALIDENTIFIER as Article,,

"MERCHANDISECATEGORY_ID" as ArticleGroupID

where len(EXTERNALIDENTIFIER)>=7;

SQL SELECT *
FROM MSMATERIAL;

Re: Do not load all data

Wed, 28 Dec 2011 13:30:34 GMT

Length did work. thanks