topic Load * with an acception in QlikView

Load * with an acception

joris_lansdaal — Sat, 13 Aug 2016 05:50:08 GMT

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

maxgro — Sat, 13 Aug 2016 06:17:07 GMT

maybe (check if it works with section access)

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

drop field NTNAME;

rename field upperntname to NTNAME;

joris_lansdaal — Sat, 13 Aug 2016 06:30:27 GMT

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!