Log in to AnswerLog in to Follow
DM
1364Views
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
on 2017-08-17
J.
mvp_badge
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
on 2017-08-17

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
on 2019-03-13

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
on 2019-03-13
Daniël Kuhlmann
mvp_badge
MVP

Hi DM,

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

Regards,

Daniel


1
0
on 2019-03-13

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
on 2020-06-03
Daniël Kuhlmann
mvp_badge
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
on 2020-06-03

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
on 3rd Mar
Daniël Kuhlmann
mvp_badge
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
on 3rd Mar
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.