topic Re: Dynamic Rename Column on the basis of Mapping in QlikView

Dynamic Rename Column on the basis of Mapping

Anonymous — Tue, 28 Feb 2017 06:40:36 GMT

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

Re: Dynamic Rename Column on the basis of Mapping

dsharmaqv — Tue, 28 Feb 2017 06:56:59 GMT

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

Re: Dynamic Rename Column on the basis of Mapping

muthukumar77 — Tue, 28 Feb 2017 07:20:12 GMT

Hi,

Rename Fields Using

Refer this app,

Re: Dynamic Rename Column on the basis of Mapping

Anonymous — Tue, 28 Feb 2017 08:53:38 GMT

thanks deepak for frequent reply

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

Re: Dynamic Rename Column on the basis of Mapping

dsharmaqv — Tue, 28 Feb 2017 09:06:52 GMT

Hi Try this

Hide column if null

Re: Dynamic Rename Column on the basis of Mapping

muthukumar77 — Tue, 28 Feb 2017 09:21:03 GMT

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;

Re: Dynamic Rename Column on the basis of Mapping

Anonymous — Tue, 28 Feb 2017 09:21:25 GMT

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

Re: Dynamic Rename Column on the basis of Mapping

Anonymous — Tue, 28 Feb 2017 09:24:14 GMT

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

Re: Dynamic Rename Column on the basis of Mapping

emiledavis — Wed, 14 Jun 2017 22:16:21 GMT

This worked like a charm! Thank you!

Re: Dynamic Rename Column on the basis of Mapping

runelle — Wed, 14 Jun 2023 13:32:29 GMT

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