Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Mapping Column names to Column names

Hi,

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

Tags (1)
3 Replies
MVP
MVP

Re: Mapping Column names to Column names

do you mean renaming column names?

if yes

How to Rename Fields

oknotsen
Honored Contributor III

Re: Mapping Column names to Column names

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

Please include example data / source data.

May you live in interesting times!
MVP
MVP

Re: Mapping Column names to Column names

TableA:

load

  rowno() as field1,

  rand()*100 as field2,

  1 as field3

AutoGenerate  100;


if you stop the script here you get

1.jpg

FieldNameMap:

Mapping Load * inline [

OldFieldName, NewFieldName

field1, newfield1

field2, newfield2

];

Rename Fields using FieldNameMap;


2.jpg

Community Browser