Follow these steps to create the data table:
- Let's useĀ theĀ Build Data TableĀ activity to build a data table for CompanyData, as shown in the following screenshot:
- We will be looking up the customer's name and gathering their website and social media information to update our CRM. Let's create five columns for the data table so that we can gather this information. Click on DataTableĀ in the activity and within the popup, edit and rename the existing column names. Then, use the Add columnĀ option (the plus (+) sign on left) to create the rest of the columns (Company name, Website, Facebook, LinkedIn, and Twitter):
- Once added, your Data Table will look as follows. Click on OK to continue:
Make sure that you delete the default rows in the table. There is usually a row with the first column set to textĀ as shown in the preceding screenshot. Also, ensure that all five columns are of the StringĀ type.
- In the properties...