topic Rename Dinamic Fields in QlikView

Rename Dinamic Fields

handry_orozco — Wed, 25 Nov 2020 16:16:04 GMT

Hi expert

I need to rename the fields in the following table

Tabla2:

period.20101

period.20102

period.20111

period.20112

period.20121

period.20122

period.20131

....
....

Resident Table1;

Drop Table Table1;

I do not always have all the fields, it is possible that in a set I do not get the period.20101, I need to remove the word period and leave only the number

Re: Rename Dinamic Fields

isingh30 — Mon, 05 Mar 2018 17:53:33 GMT

Rename like this - period.20101 as 20101

You can hide this 'period.20101' by putting // in front.

Thank you!

Re: Rename Dinamic Fields

sasiparupudi1 — Wed, 07 Mar 2018 08:52:52 GMT

You could do something like below

Set vTableName='Table1';

Set i=1;

Let xx=NoOfFields('$(vTableName)');

Let FromField=FieldName($(i),'$(vTableName)');

Let ToField=Keepchar('$(FromField)','0123456789');

RENAME Field '$(FromField)' to '$(ToField)';

Let i=$(i)+1;

Loop While $(i)<=NoOfFields('$(vTableName)');