

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Renaming the Column in LOAD SCRIPT with Same Names
Hi All,
I have two Columns with Name in the Excel.
While Scripting I would like to change the Second "Name" as Name2.
As both the Column names are mentioned same in the Excel Sheet. How to achieve this..?
- Tags:
- qlikview_scripting
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
when you are using the file wizard, QlikView is renaming the second time, Name is label to Name1.
But it could be problematic if there are many "Name" columns and you want only to load some of them.
The best way is to load this sheet without labels (@1, @2 or something similar with xlsx) ans rename the columns by script (@1 as Name, @2 as Name2).
Regards

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Do you want this to be automated? Otherwise, the way you wrote looks fine. Did you try like below?
Load
Field1,
Name as Name2
From <>;


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please share your excel file which you want to change


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
when you are using the file wizard, QlikView is renaming the second time, Name is label to Name1.
But it could be problematic if there are many "Name" columns and you want only to load some of them.
The best way is to load this sheet without labels (@1, @2 or something similar with xlsx) ans rename the columns by script (@1 as Name, @2 as Name2).
Regards
