Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlikview User
I am using the Qualify statement, however would like to customize the statement so that I do not get a full stop, but an underscore instead
I.e What I am getting at the moment
IP_.
I would like to get rid of the full stop just so I get
IP_
Is there any way I can customize this?
Kind Regards
Helen
Hi Helen,
This cheeky little script will do that for you, I have also attached a sample file.
Kind regards
Adam
For vTable = 0 to NoOfTables() -1
Let vTableName = TableName(vTable);
For f = 1 to NoOfFields('$(vTableName)')
let vFieldOld = FieldName($(f),'$(vTableName)');
let vFieldNew = Replace('$(vFieldOld)','.','');
RENAME FIELD $(vFieldOld) to $(vFieldNew);
Next f;
Next ;
Hi Helen,
Did this do what you wanted?