Troubleshooting Missing Column in Sent Table After Update

I don’t get why the column doesn’t appear on a sent to table when I’ve added a column post-running, forced the run and it worked with a test but still didn’t add the new column!! https://screen.studio/share/FwtRiUr5?state=uploading

10 comments

· Sorted by Oldest

Ruben
·
·
Also
Ruben
·
·
I changed the name of 1 column so I’d like the new table to also be representative of this new column name, especially if I force a push
Ruben
·
·
Btw, ideally this should be automatic
Kashif J.
·
·
Hi Ruben, Thanks for reaching out! I took a look at your "Lookalike Audiences" workbook and the issue you were experiencing.
I was able to resolve this by resending the table data from "Contacts Ocean.io," which brought up the option to add the first name as a new column in the "Master Lookalike Contacts" table.
I took these steps to find the "First Name" values:
Click on the first column in the "Master Lookalike Contacts" table to view all the data that's been sent over.
You'll need to scroll down a bit to find the "First Name" value in the list. It's there, but does needs a little scrolling to find it.
Once you locate it, you can select it and add it as a column.
I'd recommend re-running the "send to table" action in the original table, and all your rows should update with the "First name" value.
I've attached a screenshot showing where to find this option.
Let me know if this worked, or if you need any further assistance!
Loading attachments
Ruben
·
·
You solved it! Thanks a lot Kashif
Kashif J.
·
·
Also, regarding the name change functionality you mentioned: There is the option to manually use the changed column name in the "Send table data" column settings as shown here (by pressing the green highlighted button):
And you can remap the new column name to an existing column in the new table here (and change the name in the new table) or use the new column name and delete the old one:
Loading attachments
Kashif J.
·
·
You can also leave a feature request about making the process automatic here! https://community.clay.com/x/feedback
Ruben
·
·
Amazing, thanks a lot
Kashif J.
·
·
No worries! If that's everything, I'll go ahead and close out this ticket, but you let me know if you have any further questions by messaging in this thread!
Ruben
·
·
Yes go for it

Ruben
·
·
Also
Ruben
·
·
I changed the name of 1 column so I’d like the new table to also be representative of this new column name, especially if I force a push
Ruben
·
·
Btw, ideally this should be automatic
Kashif J.
·
·
Hi Ruben, Thanks for reaching out! I took a look at your "Lookalike Audiences" workbook and the issue you were experiencing.
I was able to resolve this by resending the table data from "Contacts Ocean.io," which brought up the option to add the first name as a new column in the "Master Lookalike Contacts" table.
I took these steps to find the "First Name" values:
Click on the first column in the "Master Lookalike Contacts" table to view all the data that's been sent over.
You'll need to scroll down a bit to find the "First Name" value in the list. It's there, but does needs a little scrolling to find it.
Once you locate it, you can select it and add it as a column.
I'd recommend re-running the "send to table" action in the original table, and all your rows should update with the "First name" value.
I've attached a screenshot showing where to find this option.
Let me know if this worked, or if you need any further assistance!
Loading attachments
Ruben
·
·
You solved it! Thanks a lot Kashif
Kashif J.
·
·
Also, regarding the name change functionality you mentioned: There is the option to manually use the changed column name in the "Send table data" column settings as shown here (by pressing the green highlighted button):
And you can remap the new column name to an existing column in the new table here (and change the name in the new table) or use the new column name and delete the old one:
Loading attachments
Kashif J.
·
·
You can also leave a feature request about making the process automatic here! https://community.clay.com/x/feedback
Ruben
·
·
Amazing, thanks a lot
Kashif J.
·
·
No worries! If that's everything, I'll go ahead and close out this ticket, but you let me know if you have any further questions by messaging in this thread!
Ruben
·
·
Yes go for it