Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Double click on blank column and give labeling.
Attached screenshot for reference.
Regards,
Mayank
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.
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
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.