Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there, I've got a shameful problem with some SQL.
In my script, I load my DB, but I've figured out that there was some records in February 30th, so I want to remove them from the base in qlikview without delete them in the real DB.
So when I load the concerned table, I do :
table_calendrier:
SQL SELECT *
FROM `004 le calendrier`
WHERE ((NUM_MOIS<>2) AND (NUM_JOUR<>30));
The thing is that the WHERE doesn't work, it deletes all the data in february, not the 30th. Am I simply wrong vith my statement or there is a problem with my syntax ?
Thanks !
Hi!
Maybe this:
SQL SELECT *
FROM `004 le calendrier`
WHERE NOT ((NUM_MOIS=2) AND (NUM_JOUR=30));
Hi!
Maybe this:
SQL SELECT *
FROM `004 le calendrier`
WHERE NOT ((NUM_MOIS=2) AND (NUM_JOUR=30));
try this
table_calendrier:
load *
WHERE NUM_MOIS<>2 AND NUM_JOUR<>30;
SQL SELECT *
FROM `004 le calendrier`;
Hi
Try like this
Load * WHERE NOT NUM_MOIS&'_'&NUM_JOUR = 2_30;
SQL SELECT *
FROM `004 le calendrier`;
Thanks everyone, I think I'm just an idiot for not thinking of that solution.