You connect to a database server by using Tableau Prep The database server has a data role named Role1.
You have the following field in the data.
You need to apply the Role1 data role to the Material field.
Which two actions should you perform? (Choose two.)
To apply the Role1 data role to the Material field in Tableau Prep, you need to group values that are similar but misspelled or have slight variations, and also need to filter to show only valid values that align with the data role. Grouping values using the 'Group Values' option under the 'Spelling' selection helps to consolidate and correct variations such as 'Brick' and 'Brik' or 'steel' and 'Stel'. Once the values are grouped correctly, selecting 'Valid' in the 'Show values' section ensures that only values that adhere to the data role Role1 are displayed and included in the analysis.
Option B is correct because filtering the selected values from the More actions menu allows you to apply the data role Role1 to the Material field by specifying which values are included based on the data role. Option D is correct because selecting the data type of the Material field as Custom and then choosing Role1 allows you to explicitly assign the Role1 data role to the Material field, ensuring that it is properly controlled and managed according to the specified role's permissions and restrictions.
i believe it should be first D the A to group values based on spelling to get rid of misspelt words
Custom role has been retired from tableau since Feb 2024