Expand my Community achievements bar.

SOLVED

Apply filter in typology

Avatar

Level 2

Hi ,

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.

example

Recipient  

1

2

3

other is coming from employee table

1    a

1   b

2    c

Before delivery target data of campaign previous  has  below data which is passed to typology

1 a

1 b

1 c

3 a

while applying this typology we should have data should be written in broadlog as

1c

3 a

Rest data go to exclusion log

1    a

1   b

2    c

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi,

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.

Thanks.

View solution in original post

4 Replies

Avatar

Level 4

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

Avatar

Level 2

Hi,

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.

Avatar

Correct answer by
Community Advisor

Hi,

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.

Thanks.

Avatar

Level 3

Hi,

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.

Sourav