Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
joris_lansdaal
Contributor

Load * with an acception

Hi all,

for section access I need to load give or take 25 fields. I can't use Load * because I need UPPER(NTNAME) as NTNAME.

Ís there a simple solution or should i hard code all the fields like:

table:

Load

     UPPER(NTNAME) as NTNAME,

     SH00

     SH01

     ....

     SH24

     SH25

from ......;

thanks

1 Solution

Accepted Solutions
MVP
MVP

Re: Load * with an acception

maybe (check if it works with section access)

load UPPER(NTNAME) as upperntname, * from .....;

drop field NTNAME;

rename field upperntname to NTNAME;

2 Replies
MVP
MVP

Re: Load * with an acception

maybe (check if it works with section access)

load UPPER(NTNAME) as upperntname, * from .....;

drop field NTNAME;

rename field upperntname to NTNAME;

joris_lansdaal
Contributor

Re: Load * with an acception

I can also use this principle at the step where I load the data from excel into a QVD. And then NTNAME will already be in upper.

Thanks!

Community Browser