Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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???


Tags (1)
1 Reply

Re: append all fields on load

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";

See attached.

Community Browser