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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Priotarizing data in Deduplication activity

Avatar

Level 2

Hi,

 

I want to priotarise the data using deduplication activity. Below should be the order of priotarization.

 

1. State = "Maharashtra" and City="Mumbai"

2. State = "Maharashtra" and City="Pune"

3. State = "Maharashtra" and City="Nashik"

4. State = "Karnataka" and City="Bangalore"

5. State = "Karnataka" and City="Udupi"

 

Please help.

 

1 Accepted Solution

Avatar

Correct answer by
Level 7

Hi @rupesh12 

Instead of using AND operator, try below way in 'Following a list of values'

ParthaSarathy_0-1663163265463.png

Consider we have person_ID, state and city column in CSV file.

Method: Following a list of values > in Expression, Advance selection > Edit formula using expression > state+city > Finish

ParthaSarathy_1-1663163575477.png

In Values, enter the state and city value concatenated in priority order (Refer 1st Screenshot)

example: MaharashtraMumbai, MaharashtraPune, MaharashtraNashik, KarnatakaBangalore, KarnatakaUdupi

 

Regards,

ParthaSarathy

 

View solution in original post

7 Replies

Avatar

Level 3

Hi @rupesh12 

 

You can try the method "Following a list of values" and then define the set of values you want to prioritize. 

AkshayAnand_0-1663142675785.png

 

Do let me know if you need any further help.

 

Regards

Avatar

Level 2

@AkshayAnand 

 

I tried with "Following a list of values" method but not sure how to add "AND"  operator in the expression.

Here I want State = "Maharashtra" AND City="Mumbai"

 

rupesh12_0-1663143670365.png

 

 

Thanks in advance.

 

 

 

 

Avatar

Employee Advisor

Hi @rupesh12 

Build an additional data to bind your rules to an integer value, using a series of Iif condition, then use the additional data into the dedup and sue smallest or highest depending on the order you've given...

Thanks

Denis

Avatar

Correct answer by
Level 7

Hi @rupesh12 

Instead of using AND operator, try below way in 'Following a list of values'

ParthaSarathy_0-1663163265463.png

Consider we have person_ID, state and city column in CSV file.

Method: Following a list of values > in Expression, Advance selection > Edit formula using expression > state+city > Finish

ParthaSarathy_1-1663163575477.png

In Values, enter the state and city value concatenated in priority order (Refer 1st Screenshot)

example: MaharashtraMumbai, MaharashtraPune, MaharashtraNashik, KarnatakaBangalore, KarnatakaUdupi

 

Regards,

ParthaSarathy

 

Avatar

Level 7

Tried the same with below sample file (Highlighted in green are the expected output if we keep 2 results for each identifier)

ParthaSarathy_0-1663164060996.png

And the Output:

ParthaSarathy_1-1663164105433.png

 

Avatar

Administrator

Hi @rupesh12,

Were you able to resolve this query with the help of the given solutions or do you still need more help here? Do let us know. In case the given solutions were helpful, then kindly choose the one that helped you the most as the 'Correct Reply'.
Thanks!