Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
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 = '';
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 |
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
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