Apply filter in typology

kaushalendras48

17-10-2019

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

Accepted Solutions (1)

Accepted Solutions (1)

Jyoti_Y

MVP

18-10-2019

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.

Answers (3)

Answers (3)

Sourav_Sadhu

18-10-2019

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

asktam1410

17-10-2019

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

kaushalendras48

18-10-2019

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.