topic Re: Dynamic Label name change in QlikView

Dynamic Label name change

didierodayo — Mon, 20 Feb 2017 02:14:11 GMT

Hello,

I don't know if this is possible in Qlik but I like to ask anyway.

I am trying to write a lable expression that I can use to change th

e field name
dynamically inside the table

I have a lot of fields to display and they all have 'OLD_' in front of them.
in the Label box can I write something like =Subfield(getthefield(),'OLD_',2)

so I can just paste it in all the label boxes.

any suggestion is welcomed.

Cheers

Re: Dynamic Label name change

Anil_Babu_Samineni — Mon, 20 Feb 2017 02:25:04 GMT

That is possible when you try something like below

=SubField('Old_Item','_',-1) //Here, this is complex and kills the performance. Why not simply Item on label. Any problem over here

In fact, This is very typical to write for all Dimensions, I would love to use Script level using Preceding load via All field to single field

Re: Dynamic Label name change

jonathandienst — Mon, 20 Feb 2017 05:17:03 GMT

Although you can apply labels to field names, I don't think it is possible to do it the way you suggest. It is fairly easy to rename the fields in the load script. Build a mapping table of the old and new names (fo example, in a spreadsheet), load this mapping and use the rename option Rename Fields Using MapTable.

Re: Dynamic Label name change

didierodayo — Mon, 20 Feb 2017 06:17:02 GMT

Hi Jonathan.

Reason I am not using the applymap is because I am getting the field names after Using Qualify on multiple qvd load.

These are big tables so it takes awhile to rename the fields manually.

Can we applymap after Qualify *; ?

What is the best ways to rename fields back to their filebasename after Using Applymap?

Thanks

Re: Dynamic Label name change

didierodayo — Mon, 20 Feb 2017 08:18:48 GMT

Hi Anil ,

I need something generic that could be applied to all the dimensions because I have many of them .

I think it is not possible at this stage.

I will try the apply map suggested by Jonathan.

Thanks

Re: Dynamic Label name change

adamdavi3s — Mon, 20 Feb 2017 08:21:27 GMT

Hi Didier,

I wrote a little script to do this in the load script, the only thing you have to remember is that you can not rename key fields

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)','$(vTableName)'&'.','');
     RENAME FIELD $(vFieldOld) to $(vFieldNew);
Next f; 
Next ;

Re: Dynamic Label name change

didierodayo — Mon, 20 Feb 2017 08:25:35 GMT

Thanks Adam I'll give this a shot.

Re: Dynamic Label name change

adamdavi3s — Mon, 20 Feb 2017 08:34:33 GMT

Just pondering this, you could always reverse this instead of qualifying in the first place, then you can work around the key fields issue.

for example you'd have to run this after each table load to do the 'qualifying', this code assumes your key fields are prefixed 'KEY'

Load table1 blah;

Let vTableName = TableName(table1);
For f = 1 to NoOfFields('$(vTableName)')
    let vFieldOld = FieldName($(f),'$(vTableName)');
    let vFieldNew = '$(vTableName).$(vFieldOld)';
    if(left('$(f)',3)<>'KEY') then
    RENAME FIELD $(vFieldOld) to $(vFieldNew);
    else
    endif;
    
Next f;

Then at the end just run the original script:


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)','$(vTableName)'&'.','');
    if(left('$(f)',3)<>'KEY') then
    RENAME FIELD $(vFieldOld) to $(vFieldNew);
    else
    endif;
    
Next f;
Next ;

Re: Dynamic Label name change

didierodayo — Mon, 20 Feb 2017 08:48:59 GMT

Thanks a lot Adam this second suggestion works my scenario.

Re: Dynamic Label name change

eromiyasimon — Mon, 20 Feb 2017 08:49:21 GMT

'OLD_' &''& 'Field_name'

Re: Dynamic Label name change

adamdavi3s — Mon, 20 Feb 2017 10:40:11 GMT

Excellent, please don't forget to mark the correct answer so it helps people in the future who might come across this