Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a QlikView document in which I have multiple qualified tables. In the front-end I created a number of table boxes which contain the content of those qualified tables. Now I would like to get rid of the qualified without renaming the labels one-by-one. Is there a simple way to do this?
So table contains:
Table1.Field1, Table1.Field2, Table1.Field3
And labels need to be:
Field1, Field2, Field 3
Please help! Thanks.
You can rename using a mapping table.
For example, here the mapping table has a list of old (ie: current) field names, and the new names are the 2nd column. The rename fields using fieldmap auto renames all the fields using the map.
FieldMap:
MAPPING
LOAD
oldnames,
newnames
FROM <fieldmappings>
RENAME Fields using FieldMap;
Do you need to figure out all the fields that need renaming dynamically ? or do you have a list you can create through an inline table or spreadsheet ?
Hi Jonathan,
Thanks for your swift response. Unfortunately just renaming the fields would mess up my data model since it contains a lot of similar fields. Do you have an other solution?
I don't, use you could the mapping table to 'fetch' the label but it still means putting in the right expression in each 'label' in the table box.