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:
UPPER(NTNAME) as NTNAME,
maybe (check if it works with section access)
load UPPER(NTNAME) as upperntname, * from .....;
drop field NTNAME;
rename field upperntname to NTNAME;
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.
Retrieving data ...