Morning!
How can I write multiple properties to another table to that they are in one cell? Like a source or a list.
How can I do a “vlookup” - reading data from one table (e.g. LI URL) and writing a value from a corresponding column into another table?
Andreas, could you clarify why you'd like to write fields to a different table as a source column, rather than the existing write to table set up? I'm curious what you are hoping to achieve from this
Thanks for looking into it, Tanvi. I want to take data from the first table and ideally have all the data in the other table in a more compact form. Because if I have to map out each individual data point, I’m going to be lazy to do it and I’m also going to optimize and conserve like columns. Because the whole reason I’m putting it into another table is that I don’t have enough space to run a waterfall in the original table. And also it’s good practice to do the enrichment over there. But then I realized, for example, when I do the export from the table where I run the enrichment, what I’m actually doing is export that and do a VLOOKUP in Google Sheets in order to associate the emails I found with all of the data I have in the original scoring table. This is by no means a crazy thing to do, but I could avoid that and just create the perfect export table right inside of clay if I could pull in the original data from the first table. Because then I can map this stuff out in the second table once I know what I need. Does this make sense?
Hey Andreas, here is a quick tutorial on how to conduct a Vlookup to pull data from one table to another: https://www.loom.com/share/dbae262b4c82408082bc6b64fbc587d5?sid=809cf5b9-1249-4a29-a99f-7d5d05d674ff I set this up in your table and it should finish running shortly. Let me know if this makes sense and if you have any other questions!
haha primo support right here 🙂 – appreciate you!
Got it Andreas, thanks for clarifying! In this case, I believe you can use write to table to only write over the email column and then conduct a Vlookup so all of the corresponding columns will be pulled in a single source column as you are lookup for. This way you can map the columns that are important to you!
Cheers Andreas, we appreciate you! Happy Friday!! Hope you have a great weekend :)
Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!
Hi Andreas W.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: