KPI Library Find the Most Effective KPIs for your business.eBooks Books sharing our OKR expertise, ideas and insights.OKR University OKR resources for beginners and experts.OKR Certification Iterate Faster with OKRs Coaching & Certification Programs.Why ? Know what customers like you think about us.Case Study Know why 1000s of brands trust.Integrations Integrate easily with all your favorite apps.Employee Engagement Engage, align and inspire your team.Task Management Increase day-to-day productivity.Performance Management Build a high performance team.OKR Management Strategy-execution made easy. ![]() Product Overview Know more about our products.You now have two worksheets that represent all the data you want, both of which are under 10,000 records and can individually be synced into the same Airtable destination table using multi-source sync. You could then duplicate the worksheet and change the date filter to just include records from the second year. If you wanted to bring all 18,000 records into Airtable you could filter the Worksheet using the date field to just include records for the first year, dropping the total record count below the 10,000 record limit. Example: Assume you have a Tableau worksheet containing office supply orders over the course of 2 years and the total record count is 18,000.You'll need to set up a multi-source sync or a separate synced table in Airtable for each additional Worksheet. If your Worksheet has more than 10,000 rows, you can use a filter to bring it under 10,000 rows then duplicate the Worksheet and adjust the filter to exclude the rows from Worksheet 1 and include the remaining rows in the duplicated Worksheet 2. We will only sync with the first 10,000 records from your Tableau Worksheet. In these cases, we will warn you that some non-unique records will be lost unless another field can be used. Note that there may be times when a certain field is not a good unique identifier. Since the “Order ID” field is a good identifier, we will use that field in this step. Setting the primary field in Airtable allows you to uniquely identify it in Airtable, whereas choosing it here helps us to accurately perform the sync when comparing the current state of your sync in Airtable to the information being held in Tableau. ![]() This may sound redundant since you just set the primary field in Airtable, but it isn’t. Next, you need to choose a field that uniquely identifies each record. Upon clicking the drop-down next to the Order ID field name we’ll click the Use as primary field option. Now, we want to set this Order ID field to be the primary field in Airtable since it uniquely identifies each row (record) of data. Second, it allows us to set this as the primary field. First, it is likely a better field type for this row of data. For this example, we first want to change the “Order ID” field to be a single line text field. We do our best to identify good field types for each field coming from Tableau, however, sometimes you’ll want to adjust things so they make sense in your Airtable base. This involves choosing a primary field, customizing which fields will be shown, as well as picking field types for each column (field). ![]() ![]() Next up, you’ll need to configure the fields that will be synced over to Airtable.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |