Discovering the Landing Zone

To discover the source tables:

1. Open your project.

2. In the Metadata panel, select Discover from the drop-down menu in the top right corner.

   -OR-

   In the Manage Metadata window, click the Discover toolbar button on the left.

   The Discover window opens.

3. Select the desired source Landing Zone and then click OK.

   The Source Tables/Views Selection - Name window opens.

1. Choose one of the following Search for options:

   1. To search for tables only, select Tables.

   2. To search for views only, select Views.

   3. To search for tables and views, select All.
2. To include internal Qlik tables in the search results, select the Show Internal Qlik Tables check box. This may be useful for debugging, but is not usually not necessary.

3. To only search for tables/views whose names contain a specific string, type the string in the Name field.

   For example, entering "ers" will return "customers" and "suppliers" in the search results.

4. Click the Search button.

   The resulting tables/views will be displayed in the list in the left of the window.

5. Optionally, click the Clear Cache button to clear the Landing Zone's metadata cache (tables and columns). This may be necessary, for example, if tables were added to the Landing Zone or renamed. Such tables will not appear in the table list until the cache is cleared.

6. To add all of the resulting tables/views, click the >> button (Add All)

   Information note

   You can select multiple tables/views by holding down the [Shift] (sequential selection) or [Ctrl] (non-sequential selection) button.

7. To add specific tables/views, select the desired tables and/or views and then click the > (Add) button.

   Information note

   If you add a table that already exists in the Metadata with the same name, then the new table is added with the name: source_table_name_DISCOVERED (or source_table_name_DISCOVERED_02 if the name source_table_name_DISCOVERED already exists, and so on).

   If the table contains attribute domains that differ from existing ones but have the same name, they will also be appended with the _01 suffix.

8. Click OK to add the selected tables/views to the project.

   The Generating Metadata from [Metadata Name] window opens.

   A progress bar indicates the current metadata generation progress. For each stage of the metadata generation process, a corresponding message appears in the Messages list.

9. After the metadata has been generated, click Close.
10. Repeat steps 2-12 to discover additional sources.