PDP based on multiple columns
Each row of my data can identify a type of transaction up to 6 different ways.
Example shortened to 3 transaction type columns:
I want to create a PDP policy that allows a group to view all food type transactions. The policy would need to say if column1='food' or column2='food' or column3='food' then allow Food group. I tried creating a policy for each column allowing the Food group but PDP is treating the policies as an AND and not displaying any data unless all columns on a row contain 'food'. I can create a second policy on column1 for column1='retail' and allow the 'food' group which will then create a policy of column1='food' or 'retail' allow Food group. Any ideas how I can apply PDP across multiple columns?