Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Avoiding fully qualified names of the colums in the selection box?

Hi,

i have few tables, that are qualified with table name to avoid synthetic keys between the tables.

But when user makes selection the Current selection box showing Tablename.FieldName...

is there any way to show only the fieldname in the current selections box, when selection made on fully qualified field?

Your help is greatly appreciated.

Regards,

SD

3 Replies
sunny_talwar

May be try an alternative to Current Selection Box

Current Selection Alternatives

prat1507
Specialist
Specialist

You can hide those fields by using a prefix like '%'.

Use as below

SET HidePrefix='%';

Load your field names as

LOAD

Field1 as %Field1

to avoid showing them in Current Selection Box.

Regards
Pratyush

marcus_sommer

A common recommendation is to provide only user-friendly field-names within the gui. This meant either to avoid qualifying and renaming explicit all fields manually appropriate and/or to rename them afterwards with a rename-mapping. How to, see here: How to Rename Fields.

- Marcus