How to merge cells with the same value into one large cell in big data report

What this article shares with you is about how to merge cells with the same value into a large cell in the big data report. The editor thinks it is very practical, so he shares it with you. I hope you can get something after reading this article. Let's take a look at it with the editor.

There are generally two cases of merging cells with the same value:

1. One is a relatively simple case: merging the same value of the classification or classification extension fields (as shown in the following figure: merging the supplier data with the same value)

In this case, most reporting tools can directly support it, using the grouping function.

2. The other is a more complex situation: what is to be merged at this time is not grouping fields, but dynamic merging of a single-valued data (as shown in the following figure: merging cells of the same drilling status in different months)

In this case, many report tools do not support it, and you have a lot of trouble to do it yourself. the general code logic is: first read all table data, and then find cells with the same value in accordance with the row / column. Merge cells with the same value to return to an object, and finally re-render the table to show the effect of the merged cells.

The above is how to merge the cells of the same value into a large cell in the big data report. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.