Variable to shorten column name

dhborchardt — Fri, 21 Sep 2012 16:19:28 GMT

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.

topic Variable to shorten column name in QlikView

Variable to shorten column name