Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
swarup_malli
Specialist
Specialist

Auto generate fixed nbr of columns and rows?

 

 

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

 

 

Labels (2)
12 Replies
swarup_malli
Specialist
Specialist
Author

In the generated series i do not see AZ , BZ,CZ.....IZ..

Instead AY is followed by AA .. same for BY which is followed by BA.
marcus_sommer

For me it worked:

ColumnRowMatrix.JPG

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

swarup_malli
Specialist
Specialist
Author

Thank you again Marcus!