Dynamic Column Name

[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

[Anonymous]

any help?