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?

[kuba_michalik]

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.

[Gysbert_Wassenaar]

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.

[#4]

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

[kuba_michalik]

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

[MarcoWedel]

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

[#7]

Worked perfectly! Thank you!

[MarcoWedel · Accepted solution]

You're welcome

please close this thread if there are no further questions

thanks

regards

Marco

[#9]

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?

[kuba_michalik]

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.