7 September 2022 Dropping tables and fields 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 about dropping fields and tables in Qlik Sense and QlikView: 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. Dropping multiple Qlik fields and tables at once 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. See you next Friday? More from the Bitmetric team Take your Qlik skills to the next level! Since 2013, the Masters Summit for Qlik is the premier advanced training for Qlik. Join us in Vienna and take your Qlik skills to the next level. Join the team! Enjoying these challenges? We have many more, and we’ll even pay you to solve them 😉 Check out our job opening. Data Model Friday Qlik Test Prep Script Solution How can we help? Barry has over 20 years experience as a Data & Analytics architect, developer, trainer and author. He will gladly help you with any questions you may have. Call us Mail us 25 April 2024 Over 3000 Qlik Sense servers still vulnerable to Cactus ransomware In November of last year we reported on how two critical vulnerabilities in Qlik Sense Enterprise for Windows were exploited in the Cactus ransomware campaign. As of today, over 3000 vulnerable Qlik Sense servers remain connected to the Internet. New Release Qlik Vulnerability 29 March 2024 Dealing with missing and late arriving values with OtherSymbol and other solutions Learn effective strategies for handling missing or late-arriving dimension values in Qlik with our expert guide. Discover how to use OtherSymbol, WHERE NOT EXISTS, and other solutions to deal with early-arriving facts Data Model Friday Qlik Test Prep Qlik Solution 22 March 2024 Picking the right color palette for your visualization Discover how to choose the perfect color palette for your data visualizations with our expert guide. Learn about single, categorical, sequential, and diverging color palettes to enhance your charts and graphs. Ideal for data analysts and visualizers. Friday Qlik Test Prep Qlik SenseTheme Visualization
25 April 2024 Over 3000 Qlik Sense servers still vulnerable to Cactus ransomware In November of last year we reported on how two critical vulnerabilities in Qlik Sense Enterprise for Windows were exploited in the Cactus ransomware campaign. As of today, over 3000 vulnerable Qlik Sense servers remain connected to the Internet. New Release Qlik Vulnerability
29 March 2024 Dealing with missing and late arriving values with OtherSymbol and other solutions Learn effective strategies for handling missing or late-arriving dimension values in Qlik with our expert guide. Discover how to use OtherSymbol, WHERE NOT EXISTS, and other solutions to deal with early-arriving facts Data Model Friday Qlik Test Prep Qlik Solution
22 March 2024 Picking the right color palette for your visualization Discover how to choose the perfect color palette for your data visualizations with our expert guide. Learn about single, categorical, sequential, and diverging color palettes to enhance your charts and graphs. Ideal for data analysts and visualizers. Friday Qlik Test Prep Qlik SenseTheme Visualization