Issue with Native Lookup Function: Missing Cell Details in Table Lookup

Hey Team. I am facing a issue with the native lookup function. When I click on the cell details, I am not able to see all the cell details from the other table. The table we are trying to lookup has 55 columns but then the cell details on the lookup only has 39 columns. Can you please help with this. Here is the table link. Can you please help me understand why this is the case?

10 comments

Channeled
APP
·
·
The native lookup function in Clay has an optional "Limit" input that can restrict the number of columns returned. This is designed to reduce the response size when dealing with tables that have a large number of columns. In your case, it seems the lookup might be set with a limit of 39 columns. To see all 55 columns, you'll need to adjust the lookup settings. If you can't find this option or need help modifying it, you should request human assistance by clicking on "Talk to a person" for more detailed guidance.
Sources: Lookup Rows | Documentation | Clay University Lookup Rows | Documentation | Clay University
Olivier T.
·
Yeah it's everyone mate...
Mohamed A.
·
·
sorry I did not get you. is the issue resolved or am I doing something wrong?
Mohamed A.
·
·
ok I just got it you are saying everyone is facing the same issue? Are we working on fix if so?
Olivier T.
·
·
I have no clue because I'm not from Clay, so it would be a question for them Stefano
Bo (.
·
·
Hey, While the table has 55 columns, not all of them contain data for every row — many towards the end are empty, which is why they’re not showing in the cell details view. Some types, like people search results, also don’t display there. If you’ve already rerun the lookup and still notice missing values, let me know which specific row you’re seeing the issue on and I’ll take a closer look.
Channeled
APP
·
·
Mohamed A.
·
·
Bo (. Still the problem is not resolved. Let me give you an example. With the same look up it shows 39 columns. However, I am not able to find columns like 'ATS Comp Email Opening Paragraph' from the other table i.e. Master Company Sprint 1 sheet. Like these there are many other columns missing even though the lookup function is a match. https://app.clay.com/workspaces/408593/workbooks/wb_sM9z6gxnPARm/tables/t_zEgivQErgkuZ/views/gv_56awMTQBcpDW
Bo (.
·
·
I recorded this walkthrough video showing exactly how to set this up: https://cln.sh/8Km2zCjj Let me know if you have any follow-up questions!
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.