Skip to Content (Press Enter)
2017-06-20 09-12-32
DM
2697Views
8Comments
Check Duplicate in List of structure
Question

Hi,

I have one structure named Company[id,name] and i am appending three different company in List of Company Structure but if i will append two company with same name in list then how can i find the duplicate company in List of company ?

Thanks & Regards

DM Singh

0
0
17 Aug 2017
Copy Link
2016-04-21 20-09-55
J.
 
MVP

sorting by name and simply check current with previous for example.

if you store them in the database, just do a aggregate by name and then check on id...


0
0
17 Aug 2017
Copy Link
UserImage.jpg
Ronan T

J. wrote:

sorting by name and simply check current with previous for example.

if you store them in the database, just do a aggregate by name and then check on id...


Hi J,

If we don't have any unique attributes,how can we remove duplicate values from structure?


Regards,

Ronan


0
0
13 Mar 2019
Copy Link
2022-02-07 08-52-30
Pranav Pandey

Ronan T wrote:

J. wrote:

sorting by name and simply check current with previous for example.

if you store them in the database, just do a aggregate by name and then check on id...


Hi J,

If we don't have any unique attributes,how can we remove duplicate values from structure?


Regards,

Ronan


Hi Ronan T,

What do you mean that there is no unique column in the structure , then in that case how you know if there is duplicate value .

As you mentioned , your structure has 2 columns namely Id and name , then in this case there can be only 3 possible cases to find duplicate .

1 .When you Id has same value .

2. When your Name column has same value .

3. Both your column has same value.

based on your requirement ,

 If you don't want to insert duplicate value then before appending to the list ,use listfilter and check the condition.

If you want to find if your list has duplicate value or not , loop through your list and user listfilter on the same list . If the filtered list has 2 or more value you have duplicate entry there.

If you are getting the list from Advance SQL or Aggregate then you can do as J suggested.


0
0
13 Mar 2019
Copy Link
2024-07-05 14-16-55
Daniël Kuhlmann
 
MVP

Hi DM,

If you are using version 11, you can use the ListDistinct to remove duplicates from a list.

Regards,

Daniel


1
0
13 Mar 2019
Copy Link
UserImage.jpg
Harshita Sharma

Daniël Kuhlmann wrote:

Hi DM,

If you are using version 11, you can use the ListDistinct to remove duplicates from a list.

Regards,

Daniel



Hii Daniel,

Can u explain me how to use this List Distinct to remove duplicate in step by step manner

Thanks 

Harshita sharma

0
0
03 Jun 2020
Copy Link
2024-07-05 14-16-55
Daniël Kuhlmann
 
MVP

Hi Harshita,

https://success.outsystems.com/Documentation/11/Reference/OutSystems_APIs/System_Actions#ListDistinct

  1. Add dependency to System/ListDistinct
  2. Add the ListDistinct to your action flow
  3. Set the Input parameter SourceList to the list with duplicates
  4. The output parameter DistinctList will only include the distinct elements of the source list.

Regards,

Daniel

0
0
03 Jun 2020
Copy Link
UserImage.jpg
Sibusiso Nhleko

Hi Guys, can I find the ListDistinct  on personal environment am trying to search I can not find it from dependency am using outsystems 11

0
0
03 Mar 2021
Copy Link
2024-07-05 14-16-55
Daniël Kuhlmann
 
MVP

Replying to Sibusiso Nhleko's comment on 03 Mar 2021 13:15:45

You are awaking an old discussion from summer 2020, next time please create a new post.

That ListDistinct is available in all editions of OutSystems. It's on the system module:

0
0
03 Mar 2021
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.