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.
