topic Re: append all fields on load in QlikView

append all fields on load

Fri, 13 May 2011 12:46:49 GMT

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...

Re: append all fields on load

johnw — Fri, 13 May 2011 20:41:04 GMT

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.