topic Re: Renaming column names in QlikView

Renaming column names

Tue, 16 Feb 2016 06:39:29 GMT

Hi,

I developed a dashboard using Excel sheets as Source(Excel to QVD, QVD to dashboard). Now as a part of my project , I want to change my data source from Excel to Apache Hbase. But I dont want to change my data model.

But the problem is the column names from HBase as extra 'data:' for each column name.

For Example:

Excel Source	Hbase Source
PRD_TYP_DSC	data:PRD_TYP_DSC
CD_TYP_DATE	data:CD_TYP_DATE
TOT_AMT_DUE_IN_GC	data:TOT_AMT_DUE_IN_GC

Now I want to remove that extra 'data:' from each column. I had some 1200 columns coming from 30 tables. So I want an automated way to use rather than manually using 'as'.

Regards,

Hemanth Dasari.

Re: Renaming column names

Tue, 16 Feb 2016 07:58:02 GMT

Refer link How to Rename Fields

Re: Renaming column names

Mark_Little — Tue, 16 Feb 2016 08:06:55 GMT

HI,

Maybe have a look at this,

Friendly Name using Rename.docx

A little self promotion.

Mark

Re: Renaming column names

jagan — Tue, 16 Feb 2016 08:07:32 GMT

HI,

You can rename all the columns in a single shot by using

FieldNameMap;

Mapping Load OldFieldName, NewFieldName From FieldNames ;

Rename Fields using FieldNameMap;

Example:

FieldNameMap

LOAD

INLINE [

NewFieldName, OldFieldName

PRD_TYP_DSC,	data:PRD_TYP_DSC
CD_TYP_DATE,	data:CD_TYP_DATE
TOT_AMT_DUE_IN_GC,	data:TOT_AMT_DUE_IN_GC

];

Rename Fields using FieldNameMap;

Hope this helps you.

Regards,

jagan.