topic Re: Rename blank column header on load in QlikView

Automate rename or mapping of blank column header on load

gshockxcc — Tue, 19 Jun 2018 02:24:25 GMT

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.

Re: Rename blank column header on load

mayankraoka — Tue, 19 Jun 2018 04:04:53 GMT

Hi,

Double click on blank column and give labeling.

Attached screenshot for reference.

Regards,

Mayank

Re: Rename blank column header on load

gshockxcc — Tue, 19 Jun 2018 10:31:44 GMT

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.

Re: Rename blank column header on load

mayankraoka — Tue, 19 Jun 2018 10:54:55 GMT

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

Re: Automate rename or mapping of blank column header on load

gshockxcc — Tue, 19 Jun 2018 11:09:27 GMT

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.