Hi Smit,
Thank you for getting back to me.
The issue is a bit more complex than it initially seemed.
Here's the background:
I have a table organized by LinkedIn profile URLs. I enriched these URLs to retrieve comments, likes, and shares, which I placed into three additional columns. Then, I used an AI agent to consolidate these columns into a single nested structure (as shown in the attached image).
The purpose of this consolidation was to have each person's name and LinkedIn URL listed only once, with their associated reactions (like, comment, share) attached accordingly.
Now, the main issue:
Some individuals have interacted with multiple posts — meaning the same person appears across multiple rows in the consolidated column. However, when I use "Write to Columns," the output splits into a new table where each interaction is recorded separately. Although auto-deduplication is enabled, it doesn't solve the problem because each row corresponds to a different post URL.
As a result, it's difficult to accurately track how frequently a particular individual has interacted across different posts.
.png){kind=logo}
