Shulou(Shulou.com)06/02 Report--

This article mainly introduces "how to use Smartbi report tool to achieve and query". In daily operation, I believe that many people have doubts about how to use Smartbi report tool to achieve and query. Xiaobian consulted all kinds of data and sorted out simple and easy-to-use methods of operation. I hope it will be helpful for you to answer the doubt of "how to use Smartbi report tool to achieve and query". Next, please follow the editor to study!

A parallel query (without duplicates) is an select statement that combines the results of two or more queries into a single result set through the Union all operator. The column name in the result set is the column name of the primary query.

The difference from Union: Union automatically compresses duplicate results in multiple result sets; Union all does not process duplicate results and displays all results.

Report analysis business scenario:

An enterprise needs to count senior leaders in China and the United States, including the ID and name of each leader. Among them, the leaders in China and the United States have the same name.

Business Analysis:

Based on the two tables "employees_china" and "employees_usa", we analyze the business scenario described above as follows:

1. Obtain the data of "employees_china" table and count the ID and names of leaders in China.

2. Get the data from the "employees_usa" table and count the ID and names of regional leaders in the United States.

3. Combine the results of the two tables into a single result set, taking into account the existence of the same name, it is necessary to do a "and query (do not remove duplicate)" query relationship.

Sample effects of the Smartbi reporting tool:

Combine the results of query 1 and query 2 into a single result set and retain the same data, as shown in the figure:

Smartbi report tool implementation and query steps:

1. Create a new visual dataset and drag the "id" and "name" fields of the "employees_china" table.

The effect is as shown in the figure:

2. Create a query.

The effect is as shown in the figure:

3. In the "query 2" interface, drag the "id" and "name" fields of the "employees_usa" table.

The effect is as shown in the figure:

4. Set the query relationship of "query 2" to "and query (no duplicates)".

The effect is as shown in the figure:

5. Preview the data viewing effect.

The effect is as shown in the figure:

At this point, the study on "how to use the Smartbi reporting tool to achieve and query" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.