hey team, I built a table with first CSV and uploaded additional CSV into the table for auto-run, but for some reasons a few of the column would miss info and would not input data from the CSV. Any idea on what's happening? Did it three times to ensure I ran it with correct matching and no success.
This issue might be related to data type mismatches between your CSV columns and the Clay table columns. Here's what you should check:1. Verify that the data types in your CSV match the column types in your Clay table. Clay supports specific data types including: โข Text โข URL โข Number โข Date โข Currency โข Email โข And others 2. If the data types don't match, the import may fail to populate those specific columns. For example, if you're importing dates, they need to follow the correct format, or if you're importing numbers into a text field, this could cause issues.Double-check the data types of the columns where information is missing and ensure they align with the format of your CSV data. If the issue persists, you may need to adjust either the column types in your Clay table or format the data in your CSV accordingly. Sources: Hubspot integration overview | Documentation | Clay University Table columns overview | Documentation | Clay University