I’m working with a database that contains multiple entries per user, specifically their job experiences, where each experience is stored as a separate row. I need to aggregate these experiences into a single entry to facilitate an API call.
Could anyone guide me on how to merge these individual rows into one consolidated entry? I’m thinking of using an append operation or something similar. This merged data will then be used as input for a new database, which I’m considering naming “Nested Experiences.” In this database, the primary key would be the user ID.
Thanks for your help!