Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

append all fields on load

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

1 Reply
johnw
Champion III
Champion III

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.