7 September 2022 How to drop fields or tables in Qlik? Share this message Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question: The correct answer is D: DROP FIELD [Fieldname] FROM [Tablename]; The correct way to drop a field after it is no longer needed in Qlik is to use the drop statement. Since the drop statement is also used to drop tables, it is needed to specify what you are going to drop. In this case there are some possibilities. To specify the field or the fields you want to drop. And optionally if you want to drop them from a specific table. The options are demonstrated in the figure below: So starting with the drop statement we can choose to drop all fields using the following syntax: DROP FIELD a; However, be aware that this is only applicable to the tables loaded until that line. All tables loaded after that drop statement containing field a, will still load field a. In best practice if you want to remove those fields, use this in a clean up section at the end of the whole load script. When using a clean up script, it might very well be possible, that some of those fields need to be dropped, while others need to be kept. For example in case when link tables are created. It is then possible to specify from which table to drop the field with the following syntax: DROP FIELD a FROM x; Here field a is only dropped from table x, leaving all other instances of field a in their respective tables. If we would like to drop multiple fields or tables, it is simply done by using the plural and adding the field or table names separated by a comma: DROP TABLES x, y; In this case the tables x and y are dropped from the data model. Needless to say is that there is no option to choose to drop the tables from any other table ;). That’s it for this week. And remember: Are these questions too easy for you? If these questions are too easy for you, then you may be ready for the Masters Summit for Qlik. At the Masters Summit for Qlik, we take your Qlik skills to the next level in 3 days with deep dives about: Qlik Data ModellingQlik ScriptingSet Analysis and Advanced AggregationsSolution Architecture & PerformanceEffective VisualizationsPerformance TuningQlik Sense integration The courses are taught by Qlik veterans Rob Wunderlich, Oleg Troyanksy, Bill Lay, Nick Webster and Bitmetric’s Barry Harmsen. Together, this team brings almost 75 years of Qlik experience and has implemented hundreds of successful projects. You can find more information and registration on the Masters Summit for Qlik website. See you next week! If you have suggestions for questions, we love to hear from you via WhatsApp or at info@bitmetric.nlIf you’re enjoying these questions and want to work on stuff like this every day (but a bit more challenging), we’re always on the lookout for new colleagues. Check our job openings here.For more of these brain teasers, check out our archive of Qlik certification questions and answers.Want to stay up to date about everything Qlik? Then sign up for our newsletter below: How can we help? Feel free to contact us if you have any comments or questions. Call us Mail us 27 December 2022 Calculating fractiles in Qlik Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question about calculating fractiles in Qlik. It seems like a lot of you have spend a great time around Christmas, since we are normally used to more answers. […] Friday Qlik Test Prep Solution 21 December 2022 Sorting data in Qlik Sense Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question about sorting data in Qlik Sense. Many responses again and as expected nobody was fooled by the answers. You all got it right! The correct answer is […] Friday Qlik Test Prep Qlik 14 December 2022 Using ApplyMap in Qlik Sense Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question about using ApplyMap in Qlik Sense. Great to see so many responses and correct answers again. Luckily ApplyMap seems to be a very familiar function. The correct […] Friday Qlik Test Prep Solution
27 December 2022 Calculating fractiles in Qlik Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question about calculating fractiles in Qlik. It seems like a lot of you have spend a great time around Christmas, since we are normally used to more answers. […] Friday Qlik Test Prep Solution
21 December 2022 Sorting data in Qlik Sense Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question about sorting data in Qlik Sense. Many responses again and as expected nobody was fooled by the answers. You all got it right! The correct answer is […] Friday Qlik Test Prep Qlik
14 December 2022 Using ApplyMap in Qlik Sense Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question about using ApplyMap in Qlik Sense. Great to see so many responses and correct answers again. Luckily ApplyMap seems to be a very familiar function. The correct […] Friday Qlik Test Prep Solution