从变化的数据库中收集信息
我试图找到一种方法来搜索信息在一个大的数据库，但这个数据库是不断变化的(新表导入的API)
这个大数据库被分成6个导入的表格(每张表格上大约有250000个单元格)。这张表是产品清单。ob欧宝娱乐app手机下载
我想在这6张表上做一个vlookup来收集另一张表上的信息，但是由于源不断变化，它不起作用。
我试着把6张表的行发送到另一个稳定的表上，但是信息太多了，不起作用。即使手动操作它也不起作用。
有解决办法吗?像做一个vlookup或索引匹配在整个工作空间(而不是表)?这6张表都在同一个工作区。
非常感谢，
答案
-
她名叫Stara ✭✭✭✭✭✭我希望你一切安好!
你是否也尝试过使用Premium App、Data Shuttle和DataTable ?
这是一种选择吗?
我希望这对你有帮助!
注意安全，祝你一周愉快!
最好的
✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请支持社区将其标记为“有见地”/“投票赞成”、“很棒”或“并且”作为公认的答案。这将使其他人更容易找到解决方案或帮助回答!
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。
-
丹尼尔•威尔逊 员工
@Wethepeople使用数据表这是我的推荐!我建议你联系你的客户团队(或者如果你在那个页面上提交了一个表格，如果你不知道你的客户经理是谁，这个表格也会回到你的客户团队)。
丹尼尔·W。
ob欧宝娱乐app手机下载产品营销
内容
类别
There needs to be a line break delimiter between options.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"}]},{"discussionID":105451,"type":"question","name":"Creating Webhook with subscope","excerpt":"Hi, I am trying to create a webhook via payload with the request body like the one below, which is an example from the API document, it failed and returned a HTTP status code 400. { \"callbackUrl\": \"https:\/\/www.myApp.com\/webhooks\", \"enabled\": true, \"events\": [ \"*.*\" ], \"name\": \"Webhook for Sheet Creation\", \"version\": 1,…","categoryID":320,"dateInserted":"2023-05-18T20:42:33+00:00","dateUpdated":"2023-05-19T08:33:29+00:00","dateLastComment":"2023-05-19T14:47:36+00:00","insertUserID":161605,"insertUser":{"userID":161605,"name":"Sandy T.","url":"https:\/\/community.smartsheet.com\/profile\/Sandy%20T.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-29T14:05:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":161605,"lastUser":{"userID":161605,"name":"Sandy T.","url":"https:\/\/community.smartsheet.com\/profile\/Sandy%20T.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-29T14:05:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":44,"score":null,"hot":3368950809,"url":"https:\/\/community.smartsheet.com\/discussion\/105451\/creating-webhook-with-subscope","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105451\/creating-webhook-with-subscope","format":"Rich","tagIDs":[227],"lastPost":{"discussionID":105451,"commentID":376731,"name":"Re: Creating Webhook with subscope","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/376731#Comment_376731","dateInserted":"2023-05-19T14:47:36+00:00","insertUserID":161605,"insertUser":{"userID":161605,"name":"Sandy T.","url":"https:\/\/community.smartsheet.com\/profile\/Sandy%20T.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-29T14:05:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-19T14:47:43+00:00","dateAnswered":"2023-05-19T14:47:36+00:00","acceptedAnswers":[{"commentID":376731,"body":"
Problem solved after deleted \"enabled\": true<\/code><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"}]}],"title":"Trending in API & Developers","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
