Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
any help?