Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Apply filter in typology

Avatar

Avatar
Validate 1
Level 1
kaushalendras48
Level 1

Likes

3 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 1
kaushalendras48
Level 1

Likes

3 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
kaushalendras48
Level 1

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)

Avatar

Avatar
Boost 50
MVP
Jyoti_Y
MVP

Likes

87 likes

Total Posts

123 posts

Correct Reply

55 solutions
Top badges earned
Boost 50
Shape 1
Boost 5
Give Back 5
Give Back 3
View profile

Avatar
Boost 50
MVP
Jyoti_Y
MVP

Likes

87 likes

Total Posts

123 posts

Correct Reply

55 solutions
Top badges earned
Boost 50
Shape 1
Boost 5
Give Back 5
Give Back 3
View profile
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)

Avatar

Avatar
Validate 1
Level 3
Sourav_Sadhu
Level 3

Likes

32 likes

Total Posts

24 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 3
Sourav_Sadhu
Level 3

Likes

32 likes

Total Posts

24 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
Sourav_Sadhu
Level 3

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

Avatar

Avatar
Validate 1
Level 3
asktam1410
Level 3

Likes

18 likes

Total Posts

37 posts

Correct Reply

6 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 3
asktam1410
Level 3

Likes

18 likes

Total Posts

37 posts

Correct Reply

6 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
asktam1410
Level 3

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

Avatar

Avatar
Validate 1
Level 1
kaushalendras48
Level 1

Likes

3 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 1
kaushalendras48
Level 1

Likes

3 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
kaushalendras48
Level 1

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.