Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to append all field names on load ... Is that possible??? I can do an alias or ,FIELD as FIELD1 but i would have to do it to all the fileds...
so is there an easy way to do this like ALIAS * as *1; or do i ahve to do all fieldnames individualy???
thanks...
I believe you have to alias or rename fields individually. You can, however, rename using a loop. For instance, I can rename all fields in table Data like this:
FOR i=nooffields('Data') TO 1 STEP -1
LET vField=fieldname(i,'Data');
RENAME FIELD "$(vField)" TO "$(vField)1";
NEXT
See attached.