Dynamic Rename Column on the basis of Mapping

[Anonymous]

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_1	Data_2	Data_3	Data_4	Data_5	Data_6	Data_7
US	A	100	Bread
IN	B	200	chocolate
PAK	C	300	Pen

  Table B :

Group	Name
Data_1	Country
Data_2	Product
Data_3	Qty
Data_4	Name
Data_5
Data_6
Data_7

Required output

Country	Product	Qty	Name	Data_5	Data_6	Data_7
US	A	100	Bread
IN	B	200	chocolate
PAK	C	300	Pen

Please  find the sample qvw

[dsharmaqv · Accepted solution]

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

[muthukumar77]

Hi,

Rename Fields Using

Refer this app,

[Anonymous]

thanks deepak for  frequent reply

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

[dsharmaqv]

Hi Try this

Hide column if null

[muthukumar77]

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;

[Anonymous]

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

[Anonymous]

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]

This worked like a charm! Thank you!

[runelle]

Hi,

I am facing a similar issue with the tables in Qliksense. Is there anyway you can provide me the code on how to resolve this. I am unable to open the file/app you shared.

I am uploading my files, if you can help me with resolving this as I am working in Qliksense, would be great.

Thanks,

Runelle