This is just a small one but there are many more large ones and it's getting cumbersome to deal with.
I want one table that i can put values in and access without having to space each column manually as do now, and perhaps a better way to get a value from the table (i currently use get substring). For scale, I will need at least 2000 rows and the number only grows.
Also i'd like a way to organize the table by number values or alphabetical if possible.
I would store the data as files, maybe the source file being Excel, which you can export to text as TAB delimited when needed. If the performance is unacceptable, you could save to separate files based on some category.
Here is a simple example to get you started.
Instead of storing the data in a KM Variable, I would change to use a file.