Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
There is a floor with the dimension 141 * 50 ( lenght * breath).
I want to create a table that resembles the above floor wihth 141 columns and 50 rows.
The column should start with A,B........AB,AC.......so on and the rows should start from 1 to 50.
In essence I'm trying to create a grid using a table object
For me it worked:
If you are missing the Z's then it might be caused from differences between my default regional-settings (OS) and/or the used char-sets respectively collation-settings and your configurations. Maybe you could adjust them in any way.
Deducing from this it indicates that in your char-list is any additional/different char compared to my "standard" alphabet. To know it might be useful for any adjusting approaches to the settings.
An alternatively might be just to increase the number of chars by using 27 instead of 26, like:
t1: load *, 1 as ID, chr(64 + if(Cluster = 1, null(), Cluster -1)) &
chr(64 + recno() - ((Cluster - 1) * 27)) as Column; load ceil(recno() / 27) as Cluster autogenerate 141;
- Marcus
Thank you again Marcus!