topic Re: Find / Replace multiple field names in QlikView

Find / Replace multiple field names

Wed, 08 Oct 2014 11:21:19 GMT

I'm renaming various fields in the script and I am using find / replace to change the objects.

Does anyone know of a solution that is more practical to rename fields in these objects? Macro or some other procedure?

Are many fields and would not want to do manually!

Thank you

Stive

Re: Find / Replace multiple field names

Gysbert_Wassenaar — Wed, 08 Oct 2014 11:44:11 GMT

See this blog post: How to Rename Fields

Re: Find / Replace multiple field names

Thu, 09 Oct 2014 14:38:15 GMT

Hello Gysbert Wassenaar,

Thank you for directing me to this article. Actually realized when the change is made in the script, will be automatic for the objects. I had just renamed the table field and let other fields to rename later, and just for those who were then not "accept" the change ....!

At the end I decided (due to my working model), use "as NewName Field,"! In my case it is more practical!

Also realized that when I create an action on an object: "select the field" and put the name of the field, it will not change when you do not in the script and find / replace, why put just as any name ... Table1 .field.

To work around this, put the names of fields like this: = 'Tabela1.Field'. This way does not change the script, but the find / replace can change.

Stive