In a waterfall, you can’t pull all employees into a single cell directly. Clay returns one row per person. the workaround is to use enrichment and collect list or run a subtable and then merge it into one field.
so the task i want to achieve is for a single company, i need to put all decision maker details in a single cell so that i can use it as lookup in other table
in that case you’ll need to collect all decision-maker rows into a subtable first then use summarize subtable to merge their details into a single cell. Clay doesn’t return multiple people in one row by default so this is the cleanest way to use it as a lookup.
