I am trying to make a typology rule which checks the filter criteria if the data is not matching with recipient id and employee code then it will apply.
Filtering with recipient id is easy but how to apply to value which is coming in target data but not from recipient.
other is coming from employee table
Before delivery target data of campaign previous has below data which is passed to typology
while applying this typology we should have data should be written in broadlog as
Rest data go to exclusion log
Can anyone suggest how to achieve. we are able to do that if its only id field using table exist command but not sure how to include second in comparison
You can exclude user before reaching to delivery. Design your workflow such that data which is not valid should not go to delivery.
If it's mandatory that you want to do it in typology, then you can define linking in table so that you can filter on both table.
You can't really achieve this without creating a link between the recipient and this table. If you are fine to do this then you can use Typology or else please a Split activity before the delivery so that you can get the waterfall count and it'll not be in the target list.
if employee is prod schema - you can create a reverse link between recipient and Employee table.
Then in the typology rule you can use recipient schema as well as recipient linked schema
Sorry i missed the link the employee table has only
code and description
which coming from separate table which is coming from segment value which is user is defining after the selection.
so the data is made only on temporary data set created in workflow.
Is there any way to look into temp schema created before delivery to be referred in typology.