topic Re: Re: Updating field names in QlikView

Updating field names

Tue, 21 Oct 2014 18:49:02 GMT

I am trying to update the field names listed within my 'List Box' - the field names are pulling from a table loaded into our script. But I would like to overwrite the field names with an alias. Is this possible, without updating the source table? Can this be achieved by creating an Expression within the list box?

Re: Updating field names

kuba_michalik — Tue, 21 Oct 2014 19:15:26 GMT

Do you mean field names that you see in a dropdown when you create a new listbox and have to choose which field is it going to show? If so, then you can not change those names in any way other than aliasing or renaming them in the datamodel. You don't have to change them in the source itself, just in the loadscript. One expedient way of doing that is through the "RENAME Using" statement.

Re: Updating field names

Gysbert_Wassenaar — Tue, 21 Oct 2014 19:16:23 GMT

I'm not quite sure what you want to do, but perhaps this blog post can help you: Handling Multiple Languages. It sounds like scenario 2 from the blog post is what you're interested in.

Re: Updating field names

Tue, 21 Oct 2014 19:50:23 GMT

Thank you for your response. Can you help me build the script required? I am not familiar with the "RENAME Using" statement

List Box Details:

Filter Name = Program Name

Current Filter Fields = Bank 1, Bank 2 and Bank 3

Want to change to:

Filter Name = Program Name

Filter Fields = Program 1, Program 2, and Program 3

Re: Updating field names

kuba_michalik — Tue, 21 Oct 2014 20:41:27 GMT

I'm not fully clear on how it looks now. Could you post a screenshot?

Re: Re: Updating field names

MarcoWedel — Tue, 21 Oct 2014 20:47:44 GMT

Hi Gretchen,

I guess you are trying to replace/alias field values instead of field names, so one solution could be:

=Pick(Match([Program Name],'Bank 1','Bank 2','Bank 3'),'Program 1', 'Program 2', 'Program 3')

LOAD * INLINE [
    Program Name
    Bank 1
    Bank 2
    Bank 3
];

hope this helps

regards

Marco

Re: Re: Updating field names

Tue, 21 Oct 2014 21:12:21 GMT

Worked perfectly! Thank you!

Re: Updating field names

MarcoWedel — Tue, 21 Oct 2014 21:18:49 GMT

You're welcome

please close this thread if there are no further questions

thanks

regards

Marco

Re: Re: Updating field names

Fri, 24 Oct 2014 13:21:48 GMT

Hello,

As mentioned previously, I was able to successfully update the field names within my List Box but the field names are not flowing through to our Selection Box - is it possible to update the field names that appear there as well?

Re: Re: Re: Updating field names

kuba_michalik — Fri, 24 Oct 2014 13:48:20 GMT

That's because you've changed only what is shown in one particular listbox without touching the underlying data. If you want to change it permanently, you will need to do it in the loadscript. One possible way is this:

LOAD Pick(Match([Program Name],'Bank 1','Bank 2','Bank 3'),'Program 1', 'Program 2', 'Program 3') as [Program Name]
;
LOAD * INLINE [
    Program Name
    Bank 1
    Bank 2
    Bank 3
];

and then just use [Program Name] for the listbox.

If you have many values to change like that, a mapping table would be much better than Pick+Match.

Re: Re: Re: Updating field names

Mon, 27 Oct 2014 01:28:12 GMT

For some reason this did not work for me. I copied and pasted the 'Load Pick' Expression above - into my load script - and kept the previous Expression within the listbox, as is. Is there a way to conduct a screen share so you can see exactly what I have loaded to help resolve?

Re: Updating field names

Mon, 27 Oct 2014 05:24:16 GMT

Hi Gretcher,

As suggested if you use the below script it will change the underlying data to what you want to be displayed.

//Approach1:

TableData:

load pick(match([Program Name],'Bank 1','Bank 2','Bank 3'),'Program 1', 'Program 2', 'Program 3') as [Program Name];

LOAD * INLINE [`

Program Name

Bank 1

Bank 2

Bank 3

];

You can also use:

//Approach2:

Map1:

Mapping Load * Inline [

OldName, NewName

Bank 1, Program 1

Bank 2, Program 2

Bank 3, Program 3];

TableData:

LOAD ApplyMap('Map1',[Program Name],'AA') as [Program Name] INLINE [

Program Name

Bank 1

Bank 2

Bank 3

];

Re: Re: Re: Updating field names

kuba_michalik — Mon, 27 Oct 2014 08:33:21 GMT

This step in script does what the formula in listbox did, but permanently, on data level - do not use both. Make the listbox show "Program Name" field instead of the expression, the values are going to be changed.