topic Mapping Column names to Column names in Qlik Learning Discussions

Mapping Column names to Column names

Wed, 11 Mar 2015 18:01:39 GMT

Hi,

using "apply map" to map the column names.Please help me to undersand with examples

maxgro — Wed, 11 Mar 2015 18:31:15 GMT

do you mean renaming column names?

if yes

oknotsen — Thu, 12 Mar 2015 08:00:26 GMT

Could you please give an example of what you are trying to achieve?

Please include example data / source data.

maxgro — Thu, 12 Mar 2015 08:23:11 GMT

TableA:

load

rowno() as field1,

rand()*100 as field2,

1 as field3

AutoGenerate 100;

if you stop the script here you get

FieldNameMap:

Mapping Load * inline [

OldFieldName, NewFieldName

field1, newfield1

field2, newfield2

];

Rename Fields using FieldNameMap;