Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Tetef98
Contributor
Contributor

Drop table Where date

Bonjour,

Je charge chaque mois les données de facturation qui viennent de différents fichiers sources, sauf que la il y'avait des problèmes sur ces fichiers sources et donc ça ma générer des données fausses. Je voudrais donc drop toutes les données qui concernent le mois de juillet et les load correctement après.

Comment je peux donc faire ça, je suis nouveau sur qlik.

Merci d'avance pour votre réponse

Labels (2)
1 Reply
Bill_Britt
Former Employee
Former Employee

Every month, I load the billing data that comes from different source files, except that there were problems on these source files and therefore it generated false data. I would therefore like to drop all the data concerning the month of July and load them correctly afterwards.

So how can I do this, I'm new to qlik.

Thank you in advance for your answer


Hi,

I would think you could use a Where clause to exclude the month of July.  Then remove the Where Clause and point to the correct data.

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.