Union means that it will combine two lists. Not exactly what you want. . There is no list operation for this as far as I know
This sounds like a situation where data normalization would help you. You should create a Location entity to store your location, then associate each WarehouseTransaction to a Location.
To accomplish this, you could loop over the WarehouseTransaction entity, try to retrieve a Location with the same value, and it you cannot find one, then create it.
I read your question a couple of times before it occurred to me that if you want to source a datagrid with Location, you must have a Location entity. If you don't have one yet, you'll need one in order to have a datagrid of locations.
So lets assume you have created Location, and have a 1 to many association between Location and WarehouseTransaction (each Location can have many WarehouseTransactions, but each WarehouseTransaction can have only 1 Location). Lets also assume that this is populated as Eric describes in his answer. If you retrieve Location and use an XPath that limits the retrieve to a set of WarehouseTransactions, the Retrieve will return a unique list of Locations. For instance, lets say WarehouseTransaction has a transaction date, and your retrieve has an XPath that limits the Location to only those transactions that occurred in October 2015 (via the association between Location and WarehouseTransaction), the resulting list will contain the unique Locations that had a transaction in October.
Hope that helps,
I tried to solve it like it is described above, but I'm missing something and don't know where and what.
- One entity with a few attributes. MachineID, TransactionID (see picture) etc.. Some records have the same MachineID and I want to delete the duplicated records and after that, count all that records with the unique Machine ID.
- I have the following Microflow.