Eden G.

One more question about this column - it's been working well over the last two days but about ~10% of the rows are getting an error for this enrichment, when I force run them again it helps, but would love to avoid any manual work as this is an evergreen table. Is there a way to fix this?

That works perfectly, thank you LuisArturo!

Also just tested mapping this into HubSpot and running the update company enrichment and got an error because the date format doesnt match the one of my hubspot property. are we able to change the format of the timestamp its returning to be ONLY the date? (in the same date format (MM-DD-YYYY), just no time)

Hi Bo (. thank you for adding that! I just ran the column (the one you added) for the remainder of the rows.. it returned the date and time of when i ran it (a few min ago). thats what we want, correct? because i guess as new rows get added in to the table it will run that date stamp when it happens There are a few rows that have errors - any idea why?

Thanks for getting back to me LuisArturo! The date should be updated when a single row is updated. I added both a new row and column today

Bo (. thank you for getting back to me so quickly! Could I share you on a table where I did all of the enrichments in 1 table (import, enrich, export) so you can see if it would be worth separating out? I found that when I went to go back to reference certain things, it was difficult to find the right column as there were 60 different columns