Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Chirag_
Partner - Contributor III
Partner - Contributor III

How Do i Automatically mark table under conditional label

I want to mark certain tables that contains  Data classification - "PII"  under conditional labels 

Here is the logic i want implement:

Conditional label must be applied where Contains Data classification = "PII"

i tried Creating MQL Query but it does not parse:

SELECT Name, Object Type
WHERE category = 'Database.Tables'
AND EXISTS (
'Database.Columns' WHERE "Data Classifications" = 'PII'
)

Any solution that may help me mark Tables 

 

Regards,

Chirag

Labels (1)
1 Reply
wegan64hardy
Contributor
Contributor

You want to automatically apply a conditional label to tables that contain columns classified as PII. The idea is that if any column in a table has the data classification set to  “PII,” the table itself should inherit or be marked with a label.   ExperianCredit Login