Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello:
The question is:
After reload data to my qlickview, with one SQL SELECT, is possible delete rows of this data, with some command? for example
After SQL SELECT
DATE | Nunber | Cod | AMOUNT |
11/10/2010 | 10 | cod1 | 10 |
19/10/2010 | 20 | cod1 | 115 |
12/11/2010 | 22 | cod1 | 200 |
23/12/2010 | 30 | cod3 | 25 |
15/09/2010 | 40 | cod1 | 40 |
28/10/2010 | 255 | cod1 | 900 |
01/11/2010 | 30 | cod3 | 25 |
14/12/2010 | 15 | cod1 | 100 |
The data with the same number drop
the result
DATE | Nunber | Cod | AMOUNT |
11/10/2010 | 10 | cod1 | 10 |
19/10/2010 | 20 | cod1 | 115 |
12/11/2010 | 22 | cod1 | 200 |
15/09/2010 | 40 | cod1 | 40 |
28/10/2010 | 255 | cod1 | 900 |
14/12/2010 | 15 | cod1 | 100 |
Any idea?
Thanks!!, regards
Cèsar Estrada
Hi there, I dont quiet undertand the pattern you want to remove, do you want to remove rows with Amount equal to 25?? or rows with Cod equal to 30cod3??
For either case try something similar to the following:
Table:
Load *
where Cod <> '30cod3';
sql select *
from database;
Regards
Hi Ivan
I need delete row with the combination with the same number, code and amount.
Thanks!
Hi there, one thing i forgot is that is not recommended to do any filtering while you are load from the database, because it affects performance, for instance you can save the table in a qvd.
Regards.