Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Bart_Breekveldt
Contributor III
Contributor III

Remove table names from fieldnames

Dear community,

Fieldnames have tablenames included before loading in the Qlik Sense script. I use Unqualify, instead of qualify, but still table_names appear in front of every field. This is the only table I loaded, so the field names are not generated to differentiate them. How to solve this without doing this manually?

Fieldnames pre-loadingFieldnames pre-loading

Labels (2)
2 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

You need to rename your fields - this could be done directly/manually within the load or before the load by creating appropriate ALIAS or after the load with a mapping. More to it could you find here:

How-to-Rename-Fields 

- Marcus

 

rubenmarin

Hi, maybe table names can be more dynamic but here is a way of doing it:

// Load original table
OriginalTable:
LOAD * Inline [
ORD_ORDERS_PK, ORD_ORDERS_ORDNUM
1,1
2,2
];

// Set length of table name
LET CharsToSkip = Len('ORD_ORDERS_')+1;

// Create temporary table with relations between old names and new names
For i=0 to NoOfFields('OriginalTable')
	tmpFields:
	LOAD FieldName as OldName, Mid(FieldName, $(CharsToSkip)) as NewName;
	LOAD FieldName($(i), 'OriginalTable') as FieldName
	AutoGenerate 1;
Next

// Create map to rename fields
mapFieldNames:
Mapping LOAD OldName, NewName Resident tmpFields;
DROP Table tmpFields;

// Rename fields
RENAME Fields using mapFieldNames;