Priotarizing data in Deduplication activity

[tejashri12]

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.

[AkshayAnand]

Hi @tejashri12 

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

Do let me know if you need any further help.

Regards

[tejashri12]

@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"

Thanks in advance.

[Denis_Bozonnet]

Hi @tejashri12 

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

[tejashri12]

Hi @Denis_Bozonnet 

Could you please show how to do it?

Thanks,

[ParthaSarathy · Accepted solution]

Hi @tejashri12 

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

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

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

example: MaharashtraMumbai, MaharashtraPune, MaharashtraNashik, KarnatakaBangalore, KarnatakaUdupi

Regards,

ParthaSarathy

[ParthaSarathy]

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

And the Output:

[Sukrity_Wadhwa]

Hi @tejashri12,

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!