MENU
A data architect needs to develop a script to export tables from a model based upon rules from an independent file. The structure of the text file with the export rules is as follows:
These rules govern which table in the model to export, what the target root filename should be, and the number of copies to export.
The TableToExport values are already verified to exist in the model.
In addition, the format will always be QVD, and the copies will be incrementally numbered.
For example, the Customers table would be exported as:
What is the minimum set of scripting strategies the data architect must use?
In the provided scenario, the goal is to export tables from a Qlik Sense model based on rules specified in an external text file. The structure of the text file indicates which table to export, the filename to use, and how many copies to create.
Given this structure, the data architect needs to:
Loop through each row in the text file to process each table.
Use an IF statement to check whether the specified table exists in the model (though it's mentioned they are verified to exist, this step may involve conditional logic to ensure the rules are correctly followed).
Use another IF statement to handle the creation of multiple copies, ensuring each file is named incrementally (e.g., Clients1.qvd, Clients2.qvd, etc.).
Key Script Strategies:
Loop: A loop is necessary to iterate through each row of the text file to process the tables specified for export.
IF Statements: The first IF statement checks conditions such as whether the table should be exported (based on additional logic if needed). The second IF statement handles the creation of multiple copies by incrementing the filename.
This approach covers all the necessary logic with the minimum set of scripting strategies, ensuring that each table is exported according to the rules defined.