Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 03, 2021 01:22 AM
Hello everyone!
I need to combine several records into one so that records with the same key accumulated all linked records in one field. That is, the table looking like this:
…would be transformed into this:
Any advice is much appreciated.
Dec 03, 2021 09:33 AM
Hi,
Create new empty table, link it to this table. Return here, and copy-paste primary field into new linked field here. Your empty table will be filled with the unique U1,U2… and links. Add “Elect…” field as lookup. Trasfer it to linked.
Dec 06, 2021 07:09 AM
@Alexey_Gusev thanks for your suggestion, but I would like to avoid creating additional table. Actually, I already have a solution of my problem thanks to @JonathanBowen.