Hi, it is possible to add a column to a table that is the row number? I have asked for an AI formula but it says it is stuck on an infinite loop? The problem I am looking to solve is to only have a particular enrichment run on odd row numbers and the system row number is not a column I can select. Any other solution is appreciated.
Adding Row Numbers to a Table for Odd Row Enrichment Run - Seeking Alternative Solution | Clay
hey Lee, sadly there isn't a way to do this currently, but perhaps the could filter out by the columns that display error on the formula results or, a workaround could potentially be:
1.
export your table to a CSV
2.
edit it with Excel or sheets to assign a number to each column
3.
make a new Clay table without the enrichments, only your raw leads data and the new numerated column
4.
Use Clay's lookup function to search for the numbered column on your Main table and map it, then you'd be able to filter based on the row number.
Hi Lee (Automaly), sorry for the delay here! Is there any other metric other than odd rows and even rows that could segment the rows you're wanting to run?
Hi Anjali DeepakRubi Sandoval I am looking for an automated process. I want to use 2 different automations for the snippet. Maybe I create a formula that if the first name starts with A, C, E, etc, run X and if it starts with B, D, etc, run Y. I am looking to have variety within the content creation with as much automation as possible. Would this work?
yeah you can do that or just use ask the AI formula generator to randomize between certain numbers, then condition your enrichments to only run if the formula displays 1 or 2, for example
Lee (Automaly), got it! That's an interesting idea - you could definitely use an AI generated formula and tell it to tag rows as either X or Y depending on the letter with which the words in that column start with. And then you can set up a condition for your enrichments to only run if the formula returned either X or Y. Do you know how to set up formulas and conditional settings? Let me know