Load * with an acception

[joris_lansdaal]

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 · Accepted solution]

maybe (check if it works with section access)

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

drop field NTNAME;

rename field upperntname to NTNAME;

[joris_lansdaal]

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!