topic Re: Skip archived data in QlikView

Skip archived data

Mon, 23 Jul 2012 14:56:52 GMT

Hello,

I've been trying quite alot now, looked on the forum and i can't seem to get it working.

It's probaly very simple, but what i want to do is skip certain data.

Currently i have the following script:

ODBC CONNECT TO [xx] (XUserId is xx, XPassword is xx);
        
TABLE1:
SQL SELECT 
     creationdate,
     name,
     owner,          
     archiveid
FROM database.tablename;

When something gets archived the field archiveid gets filled in with an ID. So basicily what i want is only to import the rows what haven't been archived.

Thanks!

Re: Skip archived data

MayilVahanan — Mon, 23 Jul 2012 15:01:54 GMT

Hi,

Do you want to remove all rows and all column for particular id?? if so,

TABLE1:

SQL SELECT

creationdate,

name,

owner,

archiveid

FROM database.tablename where archieveid = "Condition";

or remove values only for paritcular id ..

TABLE1:

Load *, if(archiveid = "condition", archiveid) as Archive;

SQL SELECT

creationdate,

name,

owner,

archiveid

FROM database.tablename;

Can you say clearly the condition/

Hope it helps

Re: Skip archived data

Mon, 23 Jul 2012 15:07:10 GMT

Try the following:

ODBC CONNECT TO [xx] (XUserId is xx, XPassword is xx); TABLE1: SQL SELECT creationdate, name, owner, archiveid FROM database.tablename

Where archiveid = '';

Re: Skip archived data

Mon, 23 Jul 2012 15:12:16 GMT

Mayil Vahanan Ramasamy wrote:
Do you want to remove all rows and all column for particular id?? if so,

Yes, if archiveid contains no ID i want to load it, if it containts an ID it needs to be skipped, example i have the following information in the database:

Creationdate	name	owner	archiveid
2010	Piet	Tempstaff	1
2011	Jan	Tempstaff
2011	Jantje	Tempstaff
2012	Jantje	Tempstaff	1

I want qlikview only to load the following:

Creationdate	name	owner	archiveid
2011	Jan	Tempstaff
2011	Jantje	Tempstaff

Re: Skip archived data

MayilVahanan — Mon, 23 Jul 2012 15:26:20 GMT

Hi,

Try like this

TABLE1:

SQL SELECT

creationdate,

name,

owner,

archiveid

FROM database.tablename where archieveid = '';

Load * where len(Trim(archieveid))=0;

TABLE1:

SQL SELECT

creationdate,

name,

owner,

archiveid

FROM database.tablename ;

Hope it helps

Re: Skip archived data

Mon, 23 Jul 2012 15:31:54 GMT

Mayil Vahanan Ramasamy wrote:
Hi,
     Try like this
Load * where len(Trim(archieveid))=0;
TABLE1:
SQL SELECT
     creationdate,
     name,
     owner,
     archiveid
FROM database.tablename ;
Hope it helps

Thanks! that one worked