Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
maybe (check if it works with section access)
load UPPER(NTNAME) as upperntname, * from .....;
drop field NTNAME;
rename field upperntname to 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.
Thanks!