Forum Discussion
Dynamic column name from its value
Watch this video in which "Source" is the name of the previous step in my query.
Unfortunately, while typing, it jumped from the second line to the first line, but it is the same "Source".
Watch this video in which "Source" is the name of the previous step in my query.
Unfortunately, while typing, it jumped from the second line to the first line, but it is the same "Source".
Hi MarcelBeug,
Thanks for a great solution. Here I have some additional requirements. I need to create a global application where we will have an actual data table. But we will have another table where we will have dynamic field names. e.g.
The data table (Table1) will have.
F1 F2 and F3 fields. These fields will be used in all the charts and Slicers.
And the other table (Table2) will have.
ID F1 F2 F3 ------Columns same as Data table(Table1) name
1 X Y Z ------- Dynamic field names as values for the above line for Dept 1
2 A B C------- Dynamic field names as values for the above line for Dept 2
So, whenever Departement 1 will use my application that time the field names will be X Y Z which will replace the Data Table(Table1) field names i.e. F1 F2 & F3
If Department 2 will use my application that time the field names will be A B C which will replace the same Data Table(Table1) field names i.e F1 F2 & F3.
These changes should be dynamically applied to all the created chart objects.
Need some idea on this issue.
Thanks a Ton in advance.
Regards,
SKD