Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Maximum Column

Hi everyone.

I am trying to run a loop that will go from column 3 till the last coumn. The last column number will however vary, therefore I needed to know if there is a command to find the last column of a table please?

Regards,

Ashley.

4 Replies
jvitantonio
Specialist III
Specialist III

Hi,

Use

NoOfColumns([ total ] )

Not applicable
Author

Maybe you can use NoOfFields to get the number of columns in a table.

LET vNcolumns= NoOfFields('Table name');

Not applicable
Author

Hi.

Thank you.

Our user has changed some of their requirements now but I will try it should I still need it.

Regards,

Ashley.

Not applicable
Author

Hi.

Thank you.

Our user changed her requirement so if I still need it, I will try it out.

Regards,

Ashley.