Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
gshockxcc
Creator
Creator

Automate rename or mapping of blank column header on load

Edit: I have a number of blank column headers.  There are more than a few, so I want to automate a rename, or mapping to get rid of the blank fields.  I can't just rename each [ ] to "Spare" because then I'll have multiple fieldnames, and I'll be right back where I started.

I'm struggling with how to handle automating the rename of each blank column label on load.  The label above 'SPARE' is blank, but I don't know how to sequentially rename this field in the Load statement each time it appears.

There is more than one field like this, so I'm trying to figure out how to handle multiple columns like this.

Thanks in advance.

4 Replies
mayankraoka
Specialist
Specialist

Hi,

Double click on blank column and give labeling.

Attached screenshot for reference.

Regards,

Mayank

gshockxcc
Creator
Creator
Author

Hi, thanks for your comment.  I have done that before, however this is 1 of 2 standard templates, and there are 62 such column headers like this.

I am looking for a way to rename these in the load scripts.

Thank you.

mayankraoka
Specialist
Specialist

you can rename these in the load scripts as well Qlikview by default will give it name for ex. F2.Rename that after loading in the load scripts.

Regards,

Mayank

gshockxcc
Creator
Creator
Author

Thank you for response.  I realized that my question/problem was poorly stated.  I have edited the original post.  Please see above and let me know if your have any suggestions.  Thank you.