Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
dhborchardt
Partner - Creator
Partner - Creator

Variable to shorten column name

I need to use Qualify in my load statement often. This makes for some long column names. Instead of renaming every column is it possible to use a variable something like this:

vColNam = subfield(%ColumnName, '.' ,2)

If so, How do I indicate(call) the current column name?

An example of one of my out of control column names is: "GLQvDB_AcntAmnts.AccountDescription"

I would like the column name to be "AccountDescription".

I hoping to just copy and then paste vColNam in any label I want to shorten.


0 Replies