Qualify statement without a full stop

[helen_pip]

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

[adamdavi3s]

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 ;

[adamdavi3s]

Hi Helen,

Did this do what you wanted?