Creating a table from a database (without duplicate items)

Ask the community
,
1

My database exemple:
| NAME | EMAIL | REGION | CITY | IDNUMBER |
| A | a@a.com | RegionA | X | 123 |
| A | b@b.com | RegionA | X | 123 |
| A | c@c.com | RegionA | X | 123 |
| B | x@x.com | RegionA | Y | 321 |
| B | y@y.com | RegionA | Y | 321 |
| C | h@h.com | RegionA | X | 456 |
| D | j@j.com | Region B | B | 890 |

And i Need this table as result:
| NAME | REGION | CITY |
| A | RegionA | X |
| B | RegionA | Y |
| C | RegionA | X |

but I have some duplicate rows in my database (ex.: some rows have the same name, but with diferent email in each row). The table is showing the duplicate rows, but i need to show these items just one time (not duplicated, as the exemple above).
Sorry for my english. But thanks for the help.

2

Please, somebody help me!

3

Please. Somebody!

4

Hi
If you want to remove duplicates you will need to read the items from the database using wix code :
$w.onReady(function () {
// Run a query that returns all the items in the collection
wixData.query(“my-db”)
.limit(1000)
.find()
.then(results => {
const uniqueItems = new Set(results.items)
// Now write your code to use the unique set
})
})

5

Della, thank you so much, but i dont know how to do it… sorry.
thats the problem. I dont know how. Look to my example. i just want show one time the rows that have “idnumer” value dupliate.
So,… i think i need a loop to find if the idnumer is already in the table. else, create a row with that idnumber, the city and the name.

Could you helpe me?

6

In that case you need to filter by the ID number.
You can see a similar example in this post : https://www.wix.com/code/home/forum/questions-answers/dropdown-duplicates