This question has been asked on the forum before. Here are the answers that will be able to help you out:
I think you'll be able to figure out from those answers, but let me know if you get stuck.
what you could do is sort the list with the machine id using find list operation find the next object with same machine id, and delete the first or the found object which ever is not required. by this you need not create a new table, your existing table will be modified.
I tried to solve it with the links, they are related to my topic, but I'm stuck at the following point:
- I have 2 entities (see picture below, I had one entity before, but split it into 2 now) and I want to get one table only with the records included with an unique MachineID and with a specific ProductType. The examples in the link have only one table and not trying to match 2 tables.