Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
shweta2608
Creator
Creator

Dynamic Rename Column on the basis of Mapping

Hi Everyone ,

I stuck in the requirement ,looking for your suugestion

Table A  have list of data for different column but the name of this data column should assign on the basis of the Name present in Table B i.e. Data_1 should be changed as Country and Data_2 as Product ,

If the name of Data_1 is change as XXX in Table B  ,then it should automatically changed in the output table

  Table A :

Data_1Data_2Data_3Data_4Data_5Data_6Data_7
USA100Bread
INB200chocolate
PAKC300Pen

  Table B :

GroupName
Data_1Country
Data_2Product
Data_3Qty
Data_4Name
Data_5
Data_6
Data_7


Required output

CountryProductQtyNameData_5Data_6Data_7
USA100Bread
INB200chocolate
PAKC300Pen

Please  find the sample qvw

1 Solution

Accepted Solutions
dsharmaqv
Creator III
Creator III

Hi

If your field name is constant then you can simply give the lable name

or if you want to go for mapping then try this

How to Rename Fields using Mapping Table

How to rename a field in qlikview

hope it helps

View solution in original post

8 Replies
dsharmaqv
Creator III
Creator III

Hi

If your field name is constant then you can simply give the lable name

or if you want to go for mapping then try this

How to Rename Fields using Mapping Table

How to rename a field in qlikview

hope it helps

View solution in original post

muthukumar77
Partner
Partner

Hi,

Rename Fields Using

Refer this app,

Muthukumar Pandiyan
shweta2608
Creator
Creator

thanks deepak for  frequent reply

  I want to hide those fields at front end which are not present in Mapping table

dsharmaqv
Creator III
Creator III

Hi Try this

Hide column if null

muthukumar77
Partner
Partner

Hi,

try this,

t1:

LOAD * INLINE [  

Data_1,Data_2,Data_3

US, A, 100, Bread

IN, B, 200, chocolate

PAK, C, 300, Pen

];

MapRenameFields:

Mapping LOAD Group,Name;

LOAD * Inline [

Group, Name

Data_1, Country

Data_2, Product

Data_3, Qty

Data_4, Name

];

RENAME Fields using MapRenameFields;

Muthukumar Pandiyan
shweta2608
Creator
Creator

this will not work ..please try to learn the scenario

shweta2608
Creator
Creator

As per my scenario

Data_5,
Data_6,

Data_7,

should be present at backend but not at front end.

Data_5 will display automatically when Name is present for Data_5

emiledavis
Contributor III
Contributor III

This worked like a charm! Thank you!