Updating field names

[#1]

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?

[#2]

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?

[#3]

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

];

[kuba_michalik]

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.