Following my post.
Is there a way to filter a table according to a text column and the starting letter?
I would like to filter all texts that start with a,b,c...j. Then create another table and show only text starts with k,l,m....s, and so on.
So if I have a table with names I will get in visual1 all the names that starts with a to j, in visual2 all the names that starts with k to s, and so on.
I am taking the UNICODE of the first letter and using it in the filters.
The column I have created is - unicode(left(table1[name],1))
Then I filter according to the above - unicode > 65 and unicode < 74 (For example for Names that starts with A to J).
Looking for a more elegant solution.
Caan you post some data in the OneDrive / Google Drive and paste the link here. Also let us know what is the final output you expect.
The original issue I have is a large table with multiple records that I need to show on a monitor in the office.
So lets say I have 100 records in my table, but only 30 can be shown on the screen.
How can I show the entire table?
I thouhgt to split the table into sub-tables and to show different names.
For instance, sub-table-1 will show names from A-D, sub-table-2 will show names from E-I, sub-table-3 will show names from J-O and so on...
This is a bad solution. But the only workaround I can think of right now.
Here is an example:
List of names in the main table
I started to explore the option to create a custom visual, but couldn't find enough information about what I need and want.