I have a list of names with emails and states. Some have state, some do not.
eg
bob smith [email protected] texas
bob smith [email protected]
I want to look for duplicates by name only and keep the one where the state field is not empty.
In the above example I would keep
bob smith [email protected] texas
How can I configure the item list node (or another node?) to achieve this?
Hi @Robm
if this is a list of items you can set the item lists node to only look at one of the values in the list for the duplicate removal.
If not you will have to write a bit of javascript I guess.
Hi @BramKn
Thanks for the quick reply. What I have done is look at only selected fields and selected Full name, ie it compares on name alone. My hassle is it then removes the wrong duplicate. I want it to keep the duplicate where the state is not empty and remove the one where the state is empty.
I am hoping there is a no code way to achieve this?
Hi @Robm
There is yes, Simply sort the list first on that field. 
I think it keeps the first record it finds, so simply sort it in a way you find the records you want first.
@BramKn that makes sense.
I have added an item list node to do the sorting before the item list node that removes duplicates.
But…
The sorting is not working. I have set the sort to to simple and the field to be State. The result I would expect is to have all the items that have an empty state field to eb grouped together the and rest to be in alphbetical order depending on if ascending or descending.
Instead…
I am getting what appears to be a random order of states? What am I doing wrong?
Could you post some sample data for me to try?
Hey @Robm
Thanks for the data.
I am not sure why the ordering is not working as expected with the item lists node.
Can remember using it before, working perfectly fine. So not sure if it is the data or if there is an issue with the functionality.
It seems to do some sorting, but not completely.
If you can please also share the data here, maybe others can see what is going wrong.
Sure - here is some sample data
[
{
"Full Name": " Eugene Van Der Westhuizen",
"Mautic ID": "585",
"State": null
},
{
"Full Name": " Rick Daman",
"Mautic ID": "612",
"State": null
},
{
"Full Name": " Daniel Dillon",
"Mautic ID": "615",
"State": null
},
{
"Full Name": " Jt Basson",
"Mautic ID": "631",
"State": null
},
{
"Full Name": " Owen Johnston",
"Mautic ID": "646",
"State": null
},
{
"Full Name": " Chris Van Reenen",
"Mautic ID": "647",
"State": "Gauteng"
},
{
"Full Name": " Ian Walker",
"Mautic ID": "670",
"State": null
},
{
"Full Name": " Mick Joyce",
"Mautic ID": "671",
"State": null
},
{
"Full Name": " Andrew Rowles",
"Mautic ID": "690",
"State": null
},
{
"Full Name": " Greg Hitchins",
"Mautic ID": "717",
"State": null
},
{
"Full Name": " Andre Hawarden",
"Mautic ID": "723",
"State": null
},
{
"Full Name": " Loveday Zondi",
"Mautic ID": "729",
"State": null
},
{
"Full Name": " Brett Bursey",
"Mautic ID": "739",
"State": null
},
{
"Full Name": " Clive Evans",
"Mautic ID": "757",
"State": null
},
{
"Full Name": " Kevin Middleton",
"Mautic ID": "760",
"State": null
},
{
"Full Name": " Phil De Graaf",
"Mautic ID": "806",
"State": "Gauteng"
},
{
"Full Name": " James Dingley",
"Mautic ID": "878",
"State": null
},
{
"Full Name": " Nicola Carshagen",
"Mautic ID": "886",
"State": null
},
{
"Full Name": " Alex Masina",
"Mautic ID": "923",
"State": null
},
{
"Full Name": " Soren Bruce",
"Mautic ID": "954",
"State": null
},
{
"Full Name": " Andrew Green",
"Mautic ID": "986",
"State": null
},
{
"Full Name": " Mfanufikile Radebe",
"Mautic ID": "1002",
"State": null
},
{
"Full Name": " Dale Jackson",
"Mautic ID": "1019",
"State": null
},
{
"Full Name": " Cody Stallard",
"Mautic ID": "1021",
"State": null
},
{
"Full Name": " Rory Camp",
"Mautic ID": "1028",
"State": null
},
{
"Full Name": " David Allderman",
"Mautic ID": "1048",
"State": null
},
{
"Full Name": " Giovanni Primo",
"Mautic ID": "1073",
"State": null
},
{
"Full Name": " Ivor Smith",
"Mautic ID": "1116",
"State": null
},
{
"Full Name": " Josh Thring",
"Mautic ID": "1118",
"State": null
},
{
"Full Name": " Ron Benjano",
"Mautic ID": "583",
"State": null
},
{
"Full Name": " Paul Robinson",
"Mautic ID": "584",
"State": null
},
{
"Full Name": " Edzard Schacht",
"Mautic ID": "587",
"State": null
},
{
"Full Name": " Simon Grout",
"Mautic ID": "589",
"State": null
},
{
"Full Name": " Robert Macfarlane",
"Mautic ID": "640",
"State": null
},
{
"Full Name": " Ben Garrett",
"Mautic ID": "654",
"State": "EC"
},
{
"Full Name": " Gareth Barberton",
"Mautic ID": "705",
"State": null
},
{
"Full Name": " Kenneth Kirkby",
"Mautic ID": "707",
"State": null
},
{
"Full Name": " Kerry Louw",
"Mautic ID": "714",
"State": null
},
{
"Full Name": " Gemma Lawson",
"Mautic ID": "736",
"State": null
},
{
"Full Name": " Pieter-willem Basson",
"Mautic ID": "742",
"State": null
},
{
"Full Name": " Kate Macfarlane",
"Mautic ID": "745",
"State": null
},
{
"Full Name": " Corne Reyneke",
"Mautic ID": "747",
"State": null
},
{
"Full Name": " Olivia Read",
"Mautic ID": "752",
"State": null
},
{
"Full Name": " Anthony Welsh",
"Mautic ID": "769",
"State": "Gauteng"
},
{
"Full Name": " Hercules Sandenbergh",
"Mautic ID": "784",
"State": null
},
{
"Full Name": " Jennifer Niksch",
"Mautic ID": "809",
"State": null
},
{
"Full Name": " Tayla Norton",
"Mautic ID": "865",
"State": null
},
{
"Full Name": " Gary Clarke",
"Mautic ID": "896",
"State": null
},
{
"Full Name": " Fabian Smith",
"Mautic ID": "922",
"State": null
},
{
"Full Name": " Martin Perling",
"Mautic ID": "951",
"State": null
},
{
"Full Name": " Rachel Van Deventer",
"Mautic ID": "982",
"State": null
},
{
"Full Name": " Albert Du Toit",
"Mautic ID": "987",
"State": null
},
{
"Full Name": " Megan Alderman",
"Mautic ID": "1012",
"State": null
},
{
"Full Name": " Georg Eutermoser",
"Mautic ID": "1022",
"State": null
},
{
"Full Name": " Peter King",
"Mautic ID": "1025",
"State": null
},
{
"Full Name": " Benjamin Maehler",
"Mautic ID": "575",
"State": null
},
{
"Full Name": " Jacques Uffindell",
"Mautic ID": "604",
"State": null
},
{
"Full Name": " Clinton Cook",
"Mautic ID": "638",
"State": null
},
{
"Full Name": " Gerhard Steyn",
"Mautic ID": "645",
"State": null
},
{
"Full Name": " Stuart Roberts",
"Mautic ID": "649",
"State": null
},
{
"Full Name": " Chad Andrews",
"Mautic ID": "682",
"State": "Gauteng"
},
{
"Full Name": " Jason Brown",
"Mautic ID": "704",
"State": null
},
{
"Full Name": " Tom Ross",
"Mautic ID": "710",
"State": null
},
{
"Full Name": " Malcolm Stothard",
"Mautic ID": "713",
"State": null
},
{
"Full Name": " Mark Garden",
"Mautic ID": "738",
"State": null
},
{
"Full Name": " Robin Rheeder",
"Mautic ID": "770",
"State": null
},
{
"Full Name": " Amy Hulett",
"Mautic ID": "776",
"State": null
},
{
"Full Name": " Narine Hitchins",
"Mautic ID": "783",
"State": null
},
{
"Full Name": " Shaun Griffin",
"Mautic ID": "789",
"State": null
},
{
"Full Name": " Eric Farringer",
"Mautic ID": "918",
"State": null
},
{
"Full Name": " Rory Mcneill",
"Mautic ID": "957",
"State": null
},
{
"Full Name": " Krzysztof Lapacz",
"Mautic ID": "959",
"State": "Gauteng"
},
{
"Full Name": " Claude Nish",
"Mautic ID": "960",
"State": null
},
{
"Full Name": " Keith Flemmer",
"Mautic ID": "961",
"State": "Gauteng"
},
{
"Full Name": " Neill Hampson",
"Mautic ID": "963",
"State": null
},
{
"Full Name": " Hertz Eiselen",
"Mautic ID": "980",
"State": null
},
{
"Full Name": " Valerie Collett",
"Mautic ID": "981",
"State": null
},
{
"Full Name": " Diane Steenkamp",
"Mautic ID": "993",
"State": null
},
{
"Full Name": " Raymond Strover",
"Mautic ID": "1000",
"State": null
},
{
"Full Name": " Colin Ledwaba",
"Mautic ID": "1015",
"State": null
},
{
"Full Name": " John Black",
"Mautic ID": "1053",
"State": "EC"
},
{
"Full Name": " Sylvia Nel",
"Mautic ID": "1068",
"State": null
},
{
"Full Name": " Graydon Mitchley",
"Mautic ID": "1119",
"State": null
},
{
"Full Name": " Patrick Hemmens",
"Mautic ID": "595",
"State": "WC"
},
{
"Full Name": " Jaysen Golding",
"Mautic ID": "603",
"State": null
},
{
"Full Name": " Rusty Lawson",
"Mautic ID": "620",
"State": "KZN"
},
{
"Full Name": " Roy Delhove",
"Mautic ID": "652",
"State": null
},
{
"Full Name": " Johann Maarsingh",
"Mautic ID": "653",
"State": null
},
{
"Full Name": " Emma Hatfield",
"Mautic ID": "657",
"State": null
},
{
"Full Name": " Mike Eglington",
"Mautic ID": "661",
"State": null
},
{
"Full Name": " Dean Burscough",
"Mautic ID": "672",
"State": null
},
{
"Full Name": " Rod Penaluna",
"Mautic ID": "689",
"State": null
},
{
"Full Name": " Thulani Mbanjwa",
"Mautic ID": "691",
"State": null
},
{
"Full Name": " Annette Van Heerden",
"Mautic ID": "743",
"State": "North West"
},
{
"Full Name": " Norman Andrews",
"Mautic ID": "771",
"State": "Gauteng"
},
{
"Full Name": " David Gorven",
"Mautic ID": "772",
"State": null
},
{
"Full Name": " Mark Stewart",
"Mautic ID": "785",
"State": null
},
{
"Full Name": " Susan Lutzner",
"Mautic ID": "791",
"State": null
},
{
"Full Name": " Luke Steenkamp",
"Mautic ID": "826",
"State": null
},
{
"Full Name": " Eduard Honiball",
"Mautic ID": "912",
"State": null
},
{
"Full Name": " Richard Ford",
"Mautic ID": "956",
"State": null
},
{
"Full Name": " John Cunningham",
"Mautic ID": "965",
"State": "Gauteng"
},
{
"Full Name": " Benjamin Tarr",
"Mautic ID": "1001",
"State": null
},
{
"Full Name": " Anneke Strover",
"Mautic ID": "1016",
"State": null
},
{
"Full Name": " David Tew",
"Mautic ID": "1017",
"State": null
},
{
"Full Name": " David Mandell",
"Mautic ID": "1027",
"State": null
},
{
"Full Name": " Oliver Chater",
"Mautic ID": "1061",
"State": "KZN"
},
{
"Full Name": " Anthony Wostenholm",
"Mautic ID": "1071",
"State": null
},
{
"Full Name": " Schalk Mouton",
"Mautic ID": "1114",
"State": null
},
{
"Full Name": " Peter Flemmer",
"Mautic ID": "1115",
"State": "Gauteng"
},
{
"Full Name": " Brett Worth",
"Mautic ID": "590",
"State": null
},
{
"Full Name": " Christy Shrimpton",
"Mautic ID": "593",
"State": null
},
{
"Full Name": " Lee Furby",
"Mautic ID": "602",
"State": null
},
{
"Full Name": " Jade Dundas-starr",
"Mautic ID": "614",
"State": null
},
{
"Full Name": " Jack De Swardt",
"Mautic ID": "636",
"State": "Gauteng"
},
{
"Full Name": " Lindy Odendaal",
"Mautic ID": "651",
"State": "Gauteng"
},
{
"Full Name": " Chlodwik Rossouw",
"Mautic ID": "669",
"State": null
},
{
"Full Name": " Michael Koller",
"Mautic ID": "684",
"State": null
},
{
"Full Name": " Ian Rheeder",
"Mautic ID": "700",
"State": null
},
{
"Full Name": " Peter Griffin",
"Mautic ID": "726",
"State": null
},
{
"Full Name": " Murray Langridge",
"Mautic ID": "731",
"State": null
},
{
"Full Name": " Matthew Lunney",
"Mautic ID": "733",
"State": null
},
{
"Full Name": " Charl Lyell",
"Mautic ID": "746",
"State": null
},
{
"Full Name": " Hardi Wilkins",
"Mautic ID": "748",
"State": null
},
{
"Full Name": " Andrew Hall",
"Mautic ID": "754",
"State": "Gauteng"
},
{
"Full Name": " Murray Collier",
"Mautic ID": "788",
"State": "Gauteng"
},
{
"Full Name": " Shelley Robertson",
"Mautic ID": "803",
"State": null
},
{
"Full Name": " Garth Watters",
"Mautic ID": "905",
"State": "WC"
},
{
"Full Name": " Viviers Strydom",
"Mautic ID": "908",
"State": null
},
{
"Full Name": " Georgia Singe",
"Mautic ID": "949",
"State": null
},
{
"Full Name": " Nqobile Makhanya",
"Mautic ID": "1003",
"State": null
},
{
"Full Name": " Jabulani Gwamanda",
"Mautic ID": "1005",
"State": null
},
{
"Full Name": " Ryno Armdorf",
"Mautic ID": "1031",
"State": null
},
{
"Full Name": " Jacques Hoefnagels",
"Mautic ID": "1033",
"State": null
},
{
"Full Name": " Roger Waters",
"Mautic ID": "1047",
"State": null
},
{
"Full Name": " Msawenkosi Mtolo",
"Mautic ID": "1086",
"State": null
},
{
"Full Name": " Josh Smith",
"Mautic ID": "596",
"State": null
},
{
"Full Name": " Sarah Robinson",
"Mautic ID": "610",
"State": null
},
{
"Full Name": " Hansjorg Jehle",
"Mautic ID": "630",
"State": null
},
{
"Full Name": " Peter Geach",
"Mautic ID": "730",
"State": null
},
{
"Full Name": " Luke O'connor",
"Mautic ID": "761",
"State": null
},
{
"Full Name": " John Konyn",
"Mautic ID": "825",
"State": null
},
{
"Full Name": " Roy Carty",
"Mautic ID": "828",
"State": null
},
{
"Full Name": " Ian Marais",
"Mautic ID": "830",
"State": null
},
{
"Full Name": " Jeremy Maher",
"Mautic ID": "851",
"State": "KZN"
},
{
"Full Name": " Jenna Goddard",
"Mautic ID": "855",
"State": null
},
{
"Full Name": " Ruschay Govender",
"Mautic ID": "860",
"State": null
},
{
"Full Name": " Julian Gace",
"Mautic ID": "866",
"State": null
},
{
"Full Name": " Huntley Earle",
"Mautic ID": "875",
"State": null
},
{
"Full Name": " Robert Butcher",
"Mautic ID": "876",
"State": null
},
{
"Full Name": " Reuben Baldry",
"Mautic ID": "877",
"State": null
},
{
"Full Name": " Hana Newlands",
"Mautic ID": "882",
"State": null
},
{
"Full Name": " Shaun Lodder",
"Mautic ID": "977",
"State": null
},
{
"Full Name": " Ethan Simpson",
"Mautic ID": "1121",
"State": null
},
{
"Full Name": " Angus Dick",
"Mautic ID": "139",
"State": null
},
{
"Full Name": " Jason Ekstrand",
"Mautic ID": "578",
"State": null
},
{
"Full Name": " Rob Sutherland",
"Mautic ID": "580",
"State": "EC"
},
{
"Full Name": " Gene Prato",
"Mautic ID": "608",
"State": null
},
{
"Full Name": " Ross Palframan",
"Mautic ID": "635",
"State": "KZN"
},
{
"Full Name": " Kevin Gotte",
"Mautic ID": "655",
"State": null
},
{
"Full Name": " Jack Shooter",
"Mautic ID": "665",
"State": null
},
{
"Full Name": " Dominic Furby",
"Mautic ID": "667",
"State": null
},
{
"Full Name": " Travis Smith",
"Mautic ID": "696",
"State": null
},
{
"Full Name": " James Sharpe",
"Mautic ID": "732",
"State": "KZN"
},
{
"Full Name": " Marco Magni",
"Mautic ID": "821",
"State": "KZN"
},
{
"Full Name": " Zoog Haynes",
"Mautic ID": "823",
"State": null
},
{
"Full Name": " Brendon Thompson",
"Mautic ID": "838",
"State": null
},
{
"Full Name": " James Stutterheim",
"Mautic ID": "841",
"State": null
},
{
"Full Name": " Benjamin Bradford",
"Mautic ID": "847",
"State": null
},
{
"Full Name": " Nosipho Mthembu",
"Mautic ID": "854",
"State": null
},
{
"Full Name": " Jeremy Diedricks",
"Mautic ID": "856",
"State": null
},
{
"Full Name": " Leandri Zeelie",
"Mautic ID": "858",
"State": null
},
{
"Full Name": " Rory Treleaven",
"Mautic ID": "867",
"State": null
},
{
"Full Name": " Jess Webber",
"Mautic ID": "871",
"State": null
},
{
"Full Name": " Aiden Furby",
"Mautic ID": "873",
"State": null
},
{
"Full Name": " Vuyile Mbeje",
"Mautic ID": "892",
"State": null
},
{
"Full Name": " Wj Van Heerden",
"Mautic ID": "894",
"State": null
},
{
"Full Name": " Jacobus Van Heerden",
"Mautic ID": "895",
"State": null
},
{
"Full Name": " Joshua Fenn",
"Mautic ID": "582",
"State": null
},
{
"Full Name": " Paul Gerrard",
"Mautic ID": "605",
"State": "EC"
},
{
"Full Name": " Ian Hemingway",
"Mautic ID": "663",
"State": null
},
{
"Full Name": " Iain Hume",
"Mautic ID": "681",
"State": null
},
{
"Full Name": " Rob Collier",
"Mautic ID": "725",
"State": "Gauteng"
},
{
"Full Name": " Travis Wilkinson",
"Mautic ID": "727",
"State": null
},
{
"Full Name": " Grant Fincham",
"Mautic ID": "811",
"State": null
},
{
"Full Name": " Kelvin Herman",
"Mautic ID": "812",
"State": null
},
{
"Full Name": " James Allderman",
"Mautic ID": "813",
"State": "EC"
},
{
"Full Name": " Shaine Mcalister",
"Mautic ID": "818",
"State": null
},
{
"Full Name": " Chris Allan",
"Mautic ID": "820",
"State": null
},
{
"Full Name": " Brendon Waters",
"Mautic ID": "832",
"State": null
},
{
"Full Name": " Lyn Bennett",
"Mautic ID": "833",
"State": null
},
{
"Full Name": " Jade Wilson",
"Mautic ID": "835",
"State": null
},
{
"Full Name": " Rodger Swinney",
"Mautic ID": "843",
"State": null
},
{
"Full Name": " Joshua Glyn-cuthbert",
"Mautic ID": "850",
"State": null
},
{
"Full Name": " Daniel Mclachlan",
"Mautic ID": "857",
"State": null
},
{
"Full Name": " Shannon Gray",
"Mautic ID": "861",
"State": "KZN"
},
{
"Full Name": " Daisy May Odell",
"Mautic ID": "862",
"State": null
},
{
"Full Name": " Benjamin Jochemus Wessels",
"Mautic ID": "864",
"State": null
},
{
"Full Name": " Topeka Koning",
"Mautic ID": "887",
"State": null
},
{
"Full Name": " Libby Ross",
"Mautic ID": "893",
"State": null
},
{
"Full Name": " Josh Worthmann",
"Mautic ID": "897",
"State": null
},
{
"Full Name": " Maisy Diedricks",
"Mautic ID": "899",
"State": null
},
{
"Full Name": " Josh Edwards",
"Mautic ID": "925",
"State": null
},
{
"Full Name": " Babette Van Rooyen",
"Mautic ID": "947",
"State": null
},
{
"Full Name": " Doug Bird",
"Mautic ID": "1038",
"State": null
},
{
"Full Name": " David Hendry",
"Mautic ID": "256",
"State": "WC"
},
{
"Full Name": " Thomas King",
"Mautic ID": "257",
"State": "WC"
},
{
"Full Name": " Lizl Hobson",
"Mautic ID": "258",
"State": "WC"
},
{
"Full Name": " Cassie Van Heerden",
"Mautic ID": "259",
"State": "EC"
},
{
"Full Name": " Andre Pohl",
"Mautic ID": "260",
"State": "KZN"
},
{
"Full Name": " Johan Serdyn",
"Mautic ID": "261",
"State": "WC"
},
{
"Full Name": " Walter Hart",
"Mautic ID": "262",
"State": "WC"
},
{
"Full Name": " Michael Smit",
"Mautic ID": "424",
"State": "EC"
},
{
"Full Name": " Zack Waters",
"Mautic ID": "512",
"State": "WC"
},
{
"Full Name": " Glen Lindsay",
"Mautic ID": "513",
"State": "WC"
},
{
"Full Name": " Nic Burden",
"Mautic ID": "514",
"State": "KZN"
},
{
"Full Name": " Jason Goedhals",
"Mautic ID": "515",
"State": "EC"
},
{
"Full Name": " Karen Sinovich",
"Mautic ID": "516",
"State": "WC"
},
{
"Full Name": " Lee Moran",
"Mautic ID": "517",
"State": "WC"
},
{
"Full Name": " Richard Kohler",
"Mautic ID": "568",
"State": "WC"
},
{
"Full Name": " Fanta Gous",
"Mautic ID": "683",
"State": null
},
{
"Full Name": " Piet Jonas",
"Mautic ID": "767",
"State": null
},
{
"Full Name": " Mark Rowles",
"Mautic ID": "768",
"State": null
},
{
"Full Name": " Nathan Curry",
"Mautic ID": "773",
"State": null
},
{
"Full Name": " Joe Torlage",
"Mautic ID": "797",
"State": null
},
{
"Full Name": " Saskia Hockly",
"Mautic ID": "815",
"State": null
},
{
"Full Name": " Brad Allen",
"Mautic ID": "819",
"State": null
},
{
"Full Name": " Greig Nilsen",
"Mautic ID": "827",
"State": null
},
{
"Full Name": " Robin Tindall",
"Mautic ID": "946",
"State": "WC"
},
{
"Full Name": " Andrew Atkinson",
"Mautic ID": "966",
"State": null
},
{
"Full Name": " Johnathan Van Der Walt",
"Mautic ID": "1024",
"State": null
},
{
"Full Name": " Peter Chissano",
"Mautic ID": "1026",
"State": null
},
{
"Full Name": " Grant Tate",
"Mautic ID": "1029",
"State": null
},
{
"Full Name": " Bruce Neill",
"Mautic ID": "263",
"State": "WC"
},
{
"Full Name": " Peter O'connor",
"Mautic ID": "264",
"State": "Gauteng"
},
{
"Full Name": " Alex Cloete-hopkins",
"Mautic ID": "265",
"State": "WC"
},
{
"Full Name": " Caroline Bursey",
"Mautic ID": "266",
"State": "WC"
},
{
"Full Name": " Mike Stevens",
"Mautic ID": "267",
"State": "KZN"
},
{
"Full Name": " Daniel Jacobs",
"Mautic ID": "268",
"State": "WC"
},
{
"Full Name": " Tayne Thompson",
"Mautic ID": "269",
"State": "WC"
},
{
"Full Name": " Rob Maclean",
"Mautic ID": "270",
"State": "WC"
},
{
"Full Name": " Justin Van Winkel",
"Mautic ID": "518",
"State": "WC"
},
{
"Full Name": " Ant Lake",
"Mautic ID": "519",
"State": "WC"
},
{
"Full Name": " Rob Meintjes",
"Mautic ID": "520",
"State": "WC"
},
{
"Full Name": " Andrew Mills",
"Mautic ID": "521",
"State": "WC"
},
{
"Full Name": " Louis Eksteen",
"Mautic ID": "522",
"State": "Gauteng"
},
{
"Full Name": " Stefaans Erlank",
"Mautic ID": "523",
"State": "WC"
},
{
"Full Name": " Barry Penn",
"Mautic ID": "524",
"State": "WC"
},
{
"Full Name": " Ryno Lamont",
"Mautic ID": "525",
"State": "WC"
},
{
"Full Name": " Karl Dehining",
"Mautic ID": "526",
"State": "WC"
},
{
"Full Name": " Anya Botes",
"Mautic ID": "774",
"State": null
},
{
"Full Name": " Andrew Stone",
"Mautic ID": "775",
"State": null
},
{
"Full Name": " Chad Barker",
"Mautic ID": "777",
"State": null
},
{
"Full Name": " Peter Van Biljon",
"Mautic ID": "778",
"State": null
},
{
"Full Name": " Jonathan Cumming",
"Mautic ID": "779",
"State": null
},
{
"Full Name": " Dave Sharpe",
"Mautic ID": "780",
"State": null
},
{
"Full Name": " Andy Leith",
"Mautic ID": "781",
"State": null
},
{
"Full Name": " Lionel Gaze",
"Mautic ID": "782",
"State": null
},
{
"Full Name": " Michael Collier",
"Mautic ID": "1030",
"State": null
},
{
"Full Name": " Callan Hempel",
"Mautic ID": "1032",
"State": null
},
{
"Full Name": " David Tate",
"Mautic ID": "1034",
"State": null
},
{
"Full Name": " Gabriela Van Rooyen",
"Mautic ID": "1035",
"State": null
},
{
"Full Name": " Andrew Stewart",
"Mautic ID": "1036",
"State": null
},
{
"Full Name": " Daynie Loots",
"Mautic ID": "271",
"State": "EC"
},
{
"Full Name": " David Puttergill",
"Mautic ID": "272",
"State": "EC"
},
{
"Full Name": " Bryan Allott",
"Mautic ID": "273",
"State": "WC"
},
{
"Full Name": " Petrus Crous",
"Mautic ID": "274",
"State": "EC"
},
{
"Full Name": " Robyn Smith",
"Mautic ID": "275",
"State": "WC"
},
{
"Full Name": " Roelof Steyn",
"Mautic ID": "276",
"State": "EC"
},
{
"Full Name": " Dale Heidtmann",
"Mautic ID": "277",
"State": "EC"
},
{
"Full Name": " Evette Terblanche",
"Mautic ID": "278",
"State": "WC"
},
{
"Full Name": " Terrence Ward",
"Mautic ID": "279",
"State": "WC"
},
{
"Full Name": " Brian Wilson",
"Mautic ID": "280",
"State": "EC"
},
{
"Full Name": " Andy Birkett",
"Mautic ID": "281",
"State": "KZN"
},
{
"Full Name": " Vinnie Cicatello",
"Mautic ID": "527",
"State": "WC"
},
{
"Full Name": " Evan Ridge",
"Mautic ID": "528",
"State": "WC"
},
{
"Full Name": " Dylan Browne",
"Mautic ID": "529",
"State": "Gauteng"
},
{
"Full Name": " Oliver Fowles",
"Mautic ID": "530",
"State": "EC"
},
{
"Full Name": " Danie Liebenberg",
"Mautic ID": "531",
"State": "WC"
},
{
"Full Name": " Gavin Mcnish",
"Mautic ID": "532",
"State": "EC"
},
{
"Full Name": " Tom Gerhardt",
"Mautic ID": "533",
"State": "WC"
},
{
"Full Name": " Gary Lotter",
"Mautic ID": "534",
"State": "WC"
},
{
"Full Name": " Danie Gouws",
"Mautic ID": "535",
"State": "WC"
},
{
"Full Name": " Lucy Markewicz",
"Mautic ID": "536",
"State": "KZN"
},
{
"Full Name": " Gavin Pepler",
"Mautic ID": "537",
"State": "WC"
},
{
"Full Name": " Julian Glasspole",
"Mautic ID": "786",
"State": null
},
{
"Full Name": " Grace Casalis",
"Mautic ID": "787",
"State": null
},
{
"Full Name": " Jaydon Hunt",
"Mautic ID": "790",
"State": null
},
{
"Full Name": " Kirsty Pott",
"Mautic ID": "792",
"State": null
},
{
"Full Name": " Michael Way",
"Mautic ID": "793",
"State": null
},
{
"Full Name": " Mark Lewin",
"Mautic ID": "1039",
"State": null
},
{
"Full Name": " Mark Alderman",
"Mautic ID": "1040",
"State": null
},
{
"Full Name": " Alexander Kirn",
"Mautic ID": "1049",
"State": null
},
{
"Full Name": " Cobus Goosen",
"Mautic ID": "282",
"State": "WC"
},
{
"Full Name": " Guillaume Liebenberg",
"Mautic ID": "283",
"State": "WC"
},
{
"Full Name": " Bennie Steyn",
"Mautic ID": "284",
"State": "WC"
},
{
"Full Name": " Isabella Hart",
"Mautic ID": "285",
"State": "WC"
},
{
"Full Name": " Jeremy Louw",
"Mautic ID": "286",
"State": "WC"
},
{
"Full Name": " Marcus Badach",
"Mautic ID": "287",
"State": "WC"
},
{
"Full Name": " Santxo Etcheverry",
"Mautic ID": "288",
"State": "WC"
},
{
"Full Name": " Ruby Peterson",
"Mautic ID": "289",
"State": "WC"
},
{
"Full Name": " Marais Steyn",
"Mautic ID": "538",
"State": "WC"
},
{
"Full Name": " Jamii H",
"Mautic ID": "539",
"State": "WC"
},
{
"Full Name": " David Douglas",
"Mautic ID": "540",
"State": "KZN"
},
{
"Full Name": " Melanie Van Niekerk",
"Mautic ID": "541",
"State": "WC"
},
{
"Full Name": " Mike Martin",
"Mautic ID": "542",
"State": "WC"
},
{
"Full Name": " Sean Lourens",
"Mautic ID": "543",
"State": "WC"
},
{
"Full Name": " Ande Mazula",
"Mautic ID": "544",
"State": "WC"
},
{
"Full Name": " Rob Moody",
"Mautic ID": "545",
"State": "WC"
},
{
"Full Name": " Bruce Mcdonald",
"Mautic ID": "794",
"State": null
},
{
"Full Name": " Ruth Hatfield",
"Mautic ID": "795",
"State": null
},
{
"Full Name": " Kelby Schmidthaus",
"Mautic ID": "796",
"State": null
},
{
"Full Name": " Nathan Strachan",
"Mautic ID": "798",
"State": null
},
{
"Full Name": " Anja Marie Burger",
"Mautic ID": "799",
"State": null
},
{
"Full Name": " Paul Dias",
"Mautic ID": "800",
"State": null
},
{
"Full Name": " Roger Elliott",
"Mautic ID": "801",
"State": null
},
{
"Full Name": " Murray Starr",
"Mautic ID": "1050",
"State": null
},
{
"Full Name": " Andrew Van Osch",
"Mautic ID": "1051",
"State": null
},
{
"Full Name": " Candice Murray",
"Mautic ID": "1052",
"State": null
},
{
"Full Name": " Harry Robinson",
"Mautic ID": "1054",
"State": null
},
{
"Full Name": " Rademeyer Dippenaar",
"Mautic ID": "1055",
"State": null
},
{
"Full Name": " Nkosikhona Mabaso",
"Mautic ID": "1056",
"State": null
},
{
"Full Name": " Ross Leslie",
"Mautic ID": "1057",
"State": null
},
{
"Full Name": " Pieter Coetzer",
"Mautic ID": "290",
"State": "WC"
},
{
"Full Name": " Ivan Heesom-green",
"Mautic ID": "291",
"State": "WC"
},
{
"Full Name": " Emily Allan",
"Mautic ID": "292",
"State": "KZN"
},
{
"Full Name": " Dave Schaefer",
"Mautic ID": "293",
"State": "EC"
},
{
"Full Name": " John De Villiers",
"Mautic ID": "294",
"State": "WC"
},
{
"Full Name": " Ralph Whiting",
"Mautic ID": "295",
"State": "WC"
},
{
"Full Name": " Herbert Conradie",
"Mautic ID": "296",
"State": "WC"
},
{
"Full Name": " Michael John Townsend Martin",
"Mautic ID": "297",
"State": "WC"
},
{
"Full Name": " Richard Mcmartin",
"Mautic ID": "298",
"State": "WC"
},
{
"Full Name": " Simon Mannheim",
"Mautic ID": "546",
"State": "WC"
},
{
"Full Name": " Christiaan Botha",
"Mautic ID": "547",
"State": "WC"
},
{
"Full Name": " Willem Erasmus",
"Mautic ID": "548",
"State": "WC"
},
{
"Full Name": " Jason Collier",
"Mautic ID": "549",
"State": "WC"
},
{
"Full Name": " Matthew Gallow",
"Mautic ID": "550",
"State": "WC"
},
{
"Full Name": " Philip Pearton",
"Mautic ID": "552",
"State": "KZN"
},
{
"Full Name": " Mark Torrington",
"Mautic ID": "553",
"State": "WC"
},
{
"Full Name": " Rob Mousley",
"Mautic ID": "554",
"State": "WC"
},
{
"Full Name": " Willie Du Plessis",
"Mautic ID": "802",
"State": null
},
{
"Full Name": " Bryan Slater",
"Mautic ID": "804",
"State": null
},
{
"Full Name": " Gavin Smith",
"Mautic ID": "805",
"State": null
},
{
"Full Name": " Laurence Plant",
"Mautic ID": "807",
"State": null
},
{
"Full Name": " John Greeff",
"Mautic ID": "808",
"State": null
},
{
"Full Name": " Angie Austin",
"Mautic ID": "810",
"State": null
},
{
"Full Name": " Tori Little",
"Mautic ID": "1058",
"State": null
},
{
"Full Name": " Brandon Van Der Walt",
"Mautic ID": "1059",
"State": null
},
{
"Full Name": " Grant Truter",
"Mautic ID": "1060",
"State": null
},
{
"Full Name": " Lorna Oliver",
"Mautic ID": "1062",
"State": null
},
{
"Full Name": " Tracey Van Der Walt",
"Mautic ID": "1063",
"State": null
},
{
"Full Name": " Matthew Hampson",
"Mautic ID": "1064",
"State": null
},
{
"Full Name": " Jabu Leslie",
"Mautic ID": "1065",
"State": null
},
{
"Full Name": " Gulu Bekker",
"Mautic ID": "299",
"State": "WC"
}
]
So I solved this by hunting for a different object besides state to order the data with. I don’t know why but the state object did not allow the ordering to work properly. When I changed to a different object the ordering worked and I can control what is then removed as a duplicate
Another way to fix this is an IF node checking if the State is null. And then appending the true and false paths in a merge node.
This would make sure the records without states are at the bottom.