In Qlikview, we can rename the name of the existing fields for developing the relations among the data fields, and this process is called renaming fields. In QlikView, Data Fields are utilized as the main identifying factor for developing data associations. For Renaming the fields we use different methods like “Qualify” Statement, “Rename Field” Function. The QlikView Qualify Statement renames the data fields and delinks the links present between them. Through the given examples, you can understand how Field Renaming happens in Real-Time.

Want to Become an Expert in QlikView? Then visit here to Learn QlikView Training Online.

In this blog, we will discuss the following topics:

What are Renaming Fields?

Renaming Fields is a process of changing the names of the existing fields. Through renaming fields, we will link the data fields accurately. By Renaming Field names, we can delink the data fields. 

Renaming Fields using Qualify Statement

QlikView Qualify Statement is used for changing the provision of field names; field names will fetch the table name as an affix. 

Syntax:

Qualify *field_list

The automatic join between the fields is interrupted through the Qualify Statement. Qualify Statement Qualifies the data field name with its corresponding table. The names of the data fields are renamed, and the new names will be in the format “table name.newname”. 

table name is the same as the label of the current table. 

Related Article: [QlikView IntervalMatch Function]

                       Check Out QlikView Tutorials

We can understand the Qualify Statement in -detail through the following example:

We will create a table with the name “IT” 

ID

Course_Name

Price

1

Python

8,000

2

Java

11,000

3

.Net

13,000

4

Web Designing

10,000

 Now we will create another table and name it as “Non-IT” .

ID

Course_Name

Price

1

Autocad

12,000

2

VLSI

16,000

3

Embedded Systems

15,000

4

Digital Marketing

20,000

Now we will load the data into the Script

Qualify *;

IT:

LOAD[ID],

Course_Name,

Price

FROM

Qualify1.xlsx

(ooxml, embedded labels, table is IT);

Qualify *;

Non-IT:

LOAD[ID],

Course_Name,

Price

FROM

Qualify1.xlsx

Subscribe to our youtube channel to get new updates..!

(ooxml, embedded values, table is Non-IT)

Output:

IT.ID

1

2

3

4

 

IT.Course_Name

Python

Java

.Net

Web Designing

 

IT.Price

8,000

11,000

13,000

10,000

 

Non-IT.ID

1

2

3

4

 

Non-IT.Course_Name

Autocad

VLSI

Embedded Systems

Digital Marketing

 

Non-IT.Price

12,000

16,000

15,000

20,000

 If we did not use the Qualify statement, QlikView will map both tables as follows:

 

Course_Name

Python

Java

.Net

Web Designing

Autocad

VLSI

Embedded Systems

Digital Marketing

 

Price

8,000

11,000

13,000

10,000

12,000

16,000

15,000

20,000

Merging of the tables worked for “ID” Field and for “Course_Name” and “Price” fields did not work.

We can solve this problem by Qualifying the fields that we don’t need to get associated with. 

Qualify Course_Name,

Price;

IT:

LOAD[ID],

Course_Name,

Price

FROM

Qualify1.xlsx;

(ooxml, embedded labels, table is IT);

Qualify Course_Name,

Price;

Non-IT:

LOAD[ID],

Course_Name,

Price

FROM

Qualify1.xlsx;

(ooxml, embedded labels, table is Non-IT);

Output:

ID

1

2

3

4

 

IT.Course_Name

Python

Java

.Net

Web Designing

 

Non-IT.Course_Name

Autocad

VLSI

Embedded

Digital Marketing

 

IT.Price

8,000

11,000

13,000

10,000

 

Non-IT.Price

12,000

16,000

15,000

20,000

In the below screenshot, we can see how Qualify Statement is used in the QlikView Script:

QlikView Qualify - Renaming Fields using Qualify Statement

Renaming Field Names using AS Specifier

The AS Specifier is used in the Load statement, and we can see it in the following query:

Load ID as CustomerID, Name, Address, Phone.no, State from Customer.csv;

In the above query, we used AS Specifier to rename the “ID” Field as “CustomerID”. 

In the below screenshot, we can see how AS Specifier is used to Rename the fields.

QlikView Qualify - Renaming Field Names using AS Specifier

Rename Field Names using Alias Statement

We can rename the data fields using the Alias Statement, and Alias Statement Predates the LOAD Statement.

Example:

Alias ID as CustomerID;

Load * from Customer.csv;

In the above example, the data field from the data source “Customer.csv” with the name “ID” is renamed as “CustomerID”. This is used for creating the links with tables.

QlikView Qualify - Rename Field Names using Alias Statement

[Related Article: QlikView Metadata]

Renaming Fields using “Rename Field” Function

The Rename Field function is used to rename the fields.

Example:

Rename Field ID to CustomerID;

In the below screenshot, we can see how Rename Field function is used in the QlikView Script:

QlikView Qualify - Renaming Fields using “Rename Field” Function

Explore QlikView Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!
 
Conclusion

 There are many methods to rename the existing fields for building data associations. QlikView Qualify statement is a widely used method by the practitioners for renaming the fields. I hope this article provides you with the required information about Renaming the data fields. 

 If you have any queries, let us know by commenting in the below section.