TextUnique and TextConcatDistinct
The TextUnique aggregates text fields to distinct values while TextConcatDistinct aggregates text fields to display all possible text values in a comma delimited list.
Given this data table:
| Country | Industry | Company | 1 Day Change % (USD) | Mcap(USD) |
| AT | Financials | Erste Group Bank AG | -0.07 | 3439883100 |
| AT | Financials | Raiffeisen International Bank-Holding AG | -0.07 | 1371987780 |
| AT | Basic Materials | voestalpine AG | -0.03 | 1412883878 |
| AT | Industrials | Wienerberger AG | -0.04 | 660942066 |
| AU | Basic Materials | BHP Billiton Ltd. | -0.06 | 74380605994 |
| AU | Basic Materials | Lihir Gold Ltd. | 0.02 | 5377974426 |
| AU | Basic Materials | Fortescue Metals Group Ltd. | -0.02 | 2104618718 |
| BE | Financials | KBC Group N.V | -0.05 | 2369136539 |
| BE | Basic Materials | Solvay S.A. | -0.04 | 4151907147 |
| BE | Basic Materials | Umicore S.A | -0.03 | 2078266946 |
| CA | Consumer Goods | Magna International Inc. Cl A | -0.05 | 2981991456 |
| CA | Financials | Canadian Imperial Bank of Commerce | -0.03 | 13960011146 |
The Country, Industry, and Company are text columns while 1 Day Change % (USD) and Mcap(USD) are numeric columns.
Sample 1
Below is the defined breakdown in a Table visualization:
This Table visualization is showing the grouping of the columns based on the breakdown hierarchy with Company, 1 Day Change % (USD), and Mcap(USD) as Visual Members and with the corresponding aggregates:
| Column | Aggregate |
| Company | TextUnique |
| 1 Day Change % (USD) | Sum |
| Mcap(USD) | Sum |
By default, the aggregate of Company is set to TextUnique.
The Table visualization now displays the distinct text values of a Company for the breakdown columns, Country and Industry.
| Company | 1 Day Change % (USD) | Mcap(USD) | ||
| AT | Basic Materials | voestalpine AG | -0.03 | 1412883878 |
| Financials | -0.14 | 4811879880 | ||
| Industrials | Wienerberger AG | -0.04 | 660942066 | |
| AU | Basic Materials | -0.06 | 81863199138 | |
| BE | Basic Materials | 0.02 | 6230174093 | |
| Financials | -0.05 | 2369136539 | ||
| CA | Consumer Goods | Magna International Inc. Cl A | -0.05 | 2981991456 |
| Financials | Canadian Imperial Bank of Commerce | -0.03 | 13960011146 |
If the aggregate for the Company column is changed to TextConcatDistinct, all the text values for the corresponding breakdown columns are displayed in a comma delimited list:
| Company | 1 Day Change % (USD) | Mcap(USD) | ||
| AT | Basic Materials | voestalpine AG | -0.03 | 1412883878 |
| Financials | Erste Group Bank AG, Raiffeisen International Bank-Holding AG | -0.14 | 4811879880 | |
| Industrials | Wienerberger AG | -0.04 | 660942066 | |
| AU | Basic Materials | BHP Billiton Ltd., Lihir Gold Ltd., Fortescue Metals Group Ltd. | -0.06 | 81863199138 |
| BE | Basic Materials | Solvay S.A., Umicore S.A. | 0.02 | 6230174093 |
| Financials | KBC Group N.V. | -0.05 | 2369136539 | |
| CA | Consumer Goods | Magna International Inc. Cl A | -0.05 | 2981991456 |
| Financials | Canadian Imperial Bank of Commerce | -0.03 | 13960011146 |
You can opt to display a text column as a distinct count. Refer to Count Distinct for more information.
(c) 2013-2024 Altair Engineering Inc. All Rights Reserved.