Skip to main content
Nintex Community Menu Bar
Solved

Transfer Data without duplicates from List A to List B

  • September 23, 2022
  • 2 replies
  • 34 views
M

Hello Community, 
I'm struggling with the following issue:

- In List A I have column "colour". This column shows all possible colours (incl. duplicates). 

- Now I want to transfer List A to List B (same structure) without the duplicates.

 e.g. List A: 4x red --> List B: 1x red
        List A: 10x green --> List B: 1x green. 

 

I already tried "collections operations" with count Item but do not come to the prefered result.  

Best answer by Jake

Hi @MatsMul 

 

See attached an example based on your scenario, I am using SP16 for this but if you use another version please let me know, in the example I have used a site workflow but I don't think that matters, it is just easier to test.

 

 

Workflow looks like this:

  1. query to get all items
  2. use collection operation with "Remove Duplicates"
  3. Loop through each result
  4. Create an item

 

 

 

 

 

 

 

 

    2 replies

    Jake
    Forum|alt.badge.img+13
    • Jake
    • Scholar
    • Answer
    • September 26, 2022

    Hi @MatsMul 

     

    See attached an example based on your scenario, I am using SP16 for this but if you use another version please let me know, in the example I have used a site workflow but I don't think that matters, it is just easier to test.

     

     

    Workflow looks like this:

    1. query to get all items
    2. use collection operation with "Remove Duplicates"
    3. Loop through each result
    4. Create an item

     

     

     

     

     

     

     

     

    1 Attachments
    Jake
    M
    • MatsMul
    • Author
    • September 30, 2022
    Thank you very much.
    That works for me.
    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie SettingsAccessibility statement