Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vanand3535
Creator III
Creator III

Rename fields in Qlik Sense from data load editor

Hi all,

I have some fields like Sales_Team

where all the fields have some values like 0,1

I want to rename the fields as Sales Team, not Sales_team(I just want to remove underscore(_) sign and give space

I tried to rename Sales_team as:-

Sales_team as Sales team 

but this is showing syntax error in Qlik Sense Data load editor

Then I tried to rename as follows:-

1. Sales_team as 'Sales Team'

2. Sales_team as "Sales team"

but both ways it's renaming the field name

So, Please let me know how can I rename the field name?

Thanks,

Vivek Anand

6 Replies
arvind1494
Specialist
Specialist

Sales_team as [Sales team]

vanand3535
Creator III
Creator III
Author

I tried


Sales_team as [Sales team]


but it's not working

arvind1494
Specialist
Specialist

Metgod 1st:

Try while loading in script:

Load Sales_team as [Sales team] from  [lib://your path];

Method 2:

put this line at the end of loading script:

Rename Sales_team  to [Sales team];

raman_rastogi
Partner
Partner

Try this

Sales_team as "Sales team"


Raman

thiago_justen

Could you please share  the whole load script with us?

Sales_team as [Sales team] or Rename Field Sales_team to [Sales team] should work.

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
vanand3535
Creator III
Creator III
Author

I already tried this with both single and double quotes but I didn't get change