Skip archived data

[#1]

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!

[MayilVahanan]

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

[#3]

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


[#4]

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

[MayilVahanan · Accepted solution]

Hi,

     Try like this

TABLE1:

SQL SELECT

     creationdate,

     name,

     owner,         

     archiveid

FROM database.tablename where archieveid = '';

or

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

TABLE1:

SQL SELECT

     creationdate,

     name,

     owner,         

     archiveid

FROM database.tablename ;

Hope it helps

[#6]

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