Forum Discussion
Solved
Repeating rows in a table, show only first row
In a table visualisation, repeating rows will include the value on every row, such as this: Here there are 7 questions in a Care Profile Assessment. Repeating 'Care ...
You can use "Matrix" visual instead of "Table"
Please give this response a Thumbs Up if it answered your problem
This is easy to achieve, all you need is a row counter that starts over with each set. If your data does not have a row number you can use, create one.
For this example, we want a data dictionary where the table name is only stated once. Let's use the table INFORMATION_SCHEMA.COLUMNS as an example dataset. The column ORDINAL_POSITION provides an incrementing value, based on the column sequence in the table. Create a new column that will test this value.
TableName = IF(AllTableColumns[ORDINAL_POSITION] = 1, AllTableColumns[TABLE_NAME], BLANK())
Make sure the COLUMN_NAME is set to sort by ORDINAL_POSITION. The end result is seen in the image