QREP practice question 10 of 15

Which is the path to add a new column to a single table in a task?

Full set: 60 questions
Answer options
A: Table Selection -> Schemas -> Add Column
B: New Transformation -> Column -> Add Column
C: Select Table -> Transform -> Add New Correct answer
D: Table Settings -> General -> Add New Column
Correct Answer:
C. Select Table -> Transform -> Add New
Explanation

To add a new column to a single table within a Qlik Replicate task, the user must first navigate to the Table Selection tab. From there, the specific table is selected, and the Transform settings for that table are opened. Inside the Transform tab, the user can then use the "Add Column" function to define the new column, its data type, and an expression to populate its value. This process ensures the transformation is applied only to the selected table.

Why Incorrect

A. Table Selection -> Schemas -> Add Column: This path is incorrect. Schema-level operations are managed differently and do not involve adding a column to a single, specific table in this manner.
B. New Transformation -> Column -> Add Column: This describes the process for creating a global transformation, which would apply the new column to all tables in the task, not a single table as specified.
D. Table Settings -> General -> Add New Column: The General tab within a table's settings is used for defining properties like the target table name and schema, not for adding or transforming columns.

References

1. Qlik Replicate User Guide (May 2023): In the section "Defining transformations on a single table," the procedure is outlined. It states: "In the Table Selection tab, select the table that you want to transform. The Transform button will be enabled above the list of tables. Click Transform to open the Transform tab for the selected table... To add a column to the table, click the Add Column button..." This directly supports the path of selecting a table and then using the Transform function. (See Chapter: Using Transformations, Sub-section: Defining transformations on a single table).

2. Qlik Help - Replicate (November 2023): The online documentation for "Defining transformations on a single table" confirms the same steps. It shows that after selecting a table from the Table Selection screen, the user clicks the Transform button to access the interface for adding columns. This aligns with the sequence described in option C. (See Qlik Help Portal -> Qlik Replicate -> Transforming data -> Defining transformations on a single table).

Scroll to Top