I used Find Open Jobs waterfall to pull all job listings. I want to create ONE table that has all the job listings as separate records using. I started using Write to Other Table. Should I make separate columns for each provider? How do I get all job listings from each successful provider in one table?
Use List Mapping with write to table to consolidate all job listings into one table. Setup: 1. Select your destination table 2. Choose the column containing your job listings (the waterfall results) 3. Map the job properties (title, company, location, etc.) to columns in your new table No separate provider columns needed - write to table will create individual rows for each job listing regardless of which provider found it. Each job becomes a separate record with all relevant data mapped to your chosen columns. This approach automatically handles multiple providers by treating each job as an individual list item to be mapped.
when I try to do step 2: Choose the column containing your job listings (the waterfall results) It only let's me select one of the providers results
The Find Open Jobs waterfall automatically consolidates results from multiple providers (PredictLeads, Google Jobs, and Clay's Native Jobs Database) into a single column. When using write to table with the waterfall results, you should select the main waterfall column - not individual provider columns. The waterfall intelligently pulls data from providers in sequence until it finds results, so all job listings are already combined in one output column. If you're only seeing individual provider options, ensure you're selecting the waterfall column itself rather than the individual provider sub-columns that may appear in the interface.
The output is number of job listings not a list
The Find Open Jobs waterfall returns a "Jobs" array output, not just a count. To get individual job records in one table: 1. Select the Jobs array column (not the count column) from your waterfall results 2. Use "Send row for each item in a list" when setting up write to table 3. Map job properties (title, company, location, etc.) to your destination table columns This flattens the jobs array so each job becomes a separate row in your new table. The waterfall consolidates results from all providers into one Jobs array output.
I can't select the main waterfall column. Only the lists from the provider columns
If you can't select the main waterfall column, the value may not be formatted as a list. Add the Jobs array through the "Other data from this table" section in write to table instead. When setting up write to table: 1. Select the Jobs array data (indicated by curly brackets {}) from "Other data from this table" 2. Choose "Send row for each item in a list" 3. Map job properties (title, company, location) to your destination columns This will flatten all job listings from multiple providers into individual rows in one table.
Ok, let me try
I can't find "Choose "Send row for each item in a list""
The "Send row for each item in a list" option is found in the newer "Send table data" feature, not in the legacy "Write to Other Table" enrichment. To access it: 1. Go to Actions → Send table data (from the table actions menu) 2. Select your destination table 3. Choose "Send row for each item in a list" as your method This flattens lists so each item becomes a separate row in your destination table. The legacy "Write to Other Table" from the enrichment menu doesn't have this exact option.
https://app.clay.com/workspaces/585549/workbooks/wb_0syjaf8iAir9QNzNtUt/tables/t_0syp4ewgBmzW8PKheyW/views/gv_0syp4ewH3UGsfEF4PKd should I change the configuration output for each provider to be something different?
I'd recommend to do like in this GIF - Just simply link the lists with the forward slash. See here ! :) https://cln.sh/JF034mKr Also check these guides: 📘 Send Table Data Guide 🎥 Video walkthrough Let me know if you’d like help mapping it out.
.png){kind=logo}
