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? Take your Qlik skills to the next level! If you enjoy Qlik, you’ll love the Masters Summit for Qlik. 3 days of Qlik deep dives, peer networking, ready to use resources and much more! See you there! Test your Qlik knowledge! Check out the Friday Qlik Test Prep archive for more Qlik questions and answers. Data Model Friday Qlik Test Prep Script Solution How can we help? Feel free to contact us if you have any comments or questions. Call us Mail us 21 September 2023 Qlik Sense Enterprise for Windows – Critical Security Fix #2 A new security issue in Qlik Sense Enterprise for Windows has been identified. This resolves an incomplete fix for the vulnerability that was reported earlier this month. Patches are available and it is recommended to update your Qlik Sense Enterprise for Windows environment at the earliest possibility. New Release Qlik Security 6 September 2023 Battle Ships & Big Data: join us for some fun! Unleash the Power of Data in the Ultimate Battle Ship Game! Join us at the Big Data Expo for a thrilling experience that blends strategy, competition, and analytics. Discover how data influences gameplay and be part of our research! Plus, dive into the world of data and analytics with the experts from Bitmetric. Don’t miss out! See you at booth 46! Bitmetric Event Qlik Team 29 August 2023 Qlik Sense Enterprise for Windows – Critical Security Fixes Two security issues in Qlik Sense Enterprise for Windows have been identified and patches made available. Details can be found in Security Bulletin Critical Security fixes for Qlik Sense Enterprise for Windows (CVE-2023-41266, CVE-2023-41265). New Release Qlik Security
21 September 2023 Qlik Sense Enterprise for Windows – Critical Security Fix #2 A new security issue in Qlik Sense Enterprise for Windows has been identified. This resolves an incomplete fix for the vulnerability that was reported earlier this month. Patches are available and it is recommended to update your Qlik Sense Enterprise for Windows environment at the earliest possibility. New Release Qlik Security
6 September 2023 Battle Ships & Big Data: join us for some fun! Unleash the Power of Data in the Ultimate Battle Ship Game! Join us at the Big Data Expo for a thrilling experience that blends strategy, competition, and analytics. Discover how data influences gameplay and be part of our research! Plus, dive into the world of data and analytics with the experts from Bitmetric. Don’t miss out! See you at booth 46! Bitmetric Event Qlik Team
29 August 2023 Qlik Sense Enterprise for Windows – Critical Security Fixes Two security issues in Qlik Sense Enterprise for Windows have been identified and patches made available. Details can be found in Security Bulletin Critical Security fixes for Qlik Sense Enterprise for Windows (CVE-2023-41266, CVE-2023-41265). New Release Qlik Security