7 Replies Latest reply: Apr 2, 2014 4:52 PM by Christiani Lee-warner RSS

    Renaming Fields

    Christiani Lee-warner

      We have many Qlikview dashboards that read from multiple data sources. The data sources are QVDs, Excel, Stored Procedures from SQL Server, Sharepoint, etc. Every time that a data source change its FIELD NAMEs, I have to go into every QVW and rename the fields by either applying the "Rename" command or by manually renaming each one of them. My questions is related to "automation" on how to make this long process automated and insulate our dashboard from "surprise" data field changes. The change in field names happen very often. How do you handle these changes when you have multiple Dashboard QVWs to maintain?

        • Re: Renaming Fields
          Fernando Tonial

          Hi, see this post.

           

          How to Rename Fields

           

          Best Regards.

          Tonial.

            • Re: Renaming Fields
              Christiani Lee-warner

              Thank you for your reply! I had read this post but I think what I am looking for is an automated way to fix the issue that is already present. I currently have 27 dashboards that need to have many fields renamed. The “data source fields” have been renamed but the UI field names should remain the same. Having said that when I read the data from the “QVD” with new field names, the Dashboard QVW load fails because the data source field names have changed. Please keep in mind that the UI Names should remain the same as it was before the “data source field name” change. Thus, I was thinking of creating a “mid layer” QVW and have the renaming done by this QVW instead of on the Dashboard QVW. I would then change one variable value in my Dashboard QVW to read the “new renamed” QVD. Maybe this way I can rename the fields in all 27 dashboards without too much coding. I have not implemented or tested this idea. What do you think?

                • Re: Renaming Fields
                  NAGA CHIRANJEEVI THOTA

                  You can have one excel with two fields

                   

                  Excel:

                  Qvw_FieldName,Source_Column_Name

                   

                  Use this excel to rename fields while generating QVD.

                   

                  Whenever there is a Change in column name.Simply go to excel and change the Source_Column_Name.

                   

                  then store data into QVD.

                   

                  This way you don't need to disturb actual applications.

                  • Re: Renaming Fields
                    Fernando Tonial

                    if you rename only 1 field, it is automatically changed in the GUI.
                    I know it's hard work, but it is better to open the 27 dashboards.


                    Best Regards.

                    Tonial.

                      • Re: Renaming Fields
                        Christiani Lee-warner

                        I this case it will be a lot of fields. Close to 60 or 70 fields.

                          • Re: Renaming Fields
                            Fernando Tonial

                            Unfortunately I do not see any other way.
                            You have to change one by one and make the load of 27 dashboards for 60 or 70 times.

                              • Re: Renaming Fields
                                Christiani Lee-warner

                                So do you mean to say my suggestion posted earlier and showing here is not a good idea?

                                 

                                               Thank you for your reply! I had read this post but I think what I am looking for is an automated way to fix the issue that is already present. I currently have 27 dashboards that need to have many fields renamed. The “data source fields” have been renamed but the UI field names should remain the same. Having said that when I read the data from the “QVD” with new field names, the Dashboard QVW load fails because the data source field names have changed. Please keep in mind that the UI Names should remain the same as it was before the “data source field name” change. Thus, I was thinking of creating a “mid layer” QVW and have the renaming done by this QVW instead of on the Dashboard QVW. I would then change one variable value in my Dashboard QVW to read the “new renamed” QVD. Maybe this way I can rename the fields in all 27 dashboards without too much coding. I have not implemented or tested this idea. What do you think?