List with non-duplicate data

Julio_Hernandez · 05-07-2021 08:45 PM

HELLO COMMUNITY, I am trying to make a list of non-duplicate data but I can’t, could someone help me?

Marc_Dillon

https://community.appsheet.com/t/one-ask-about-unique/45793
https://community.appsheet.com/t/ask-about-unique/45783

It would help if you described your situation in more detail. What is a “supplier”, and where is it in this screenshot that you’re showing?

Julio_Hernandez

Hello and thanks for answering, I have a list of suppliers that I call “PROV EEDOR”, these are repeated since different products are bought with each supplier, when wanting to make a nested data template, I would like the names of these providers.
the name “PROVEE DOR” appears in the yellow cell.
I tried with this expression “unique” but it does not give me result

<<Start:unique([Related REQUISICIONs By No])>><<[PROVEEDOR]>>

Marc_Dillon

So you just want a single line per PROVEEDOR? Your current usage of UNIQUE() is doing absolutely nothing, as your “Related…” column is already a unique List of Key values. You could run a SELECT across that List, and pick only the first or last entry for each individual PROVEEDOR.

<<START: SELECT(
  [Related REQUISICIONs By No][#key-column#] ,
  [#key-column#] = MINROW( "REQUISICIONs By No" , "_RowNumber" , [#parent-ref#] = [_THISROW] )
)>>

Replace column names with “#” with the appropriate ones from your app. Replace MINROW with MAXROW to get the most recent entry instead.

Steve

I’ve deleted the duplicate posts.