Change labels dynamically in straight table

[Pedro_Rodriguez]

Hi all,

I have a bit of a challenge, I want to build a straight table whose field labels in the expressions can be changed dynamically.

The data table is called 'Data':

Field1OLD	LabelOLD1	LabelOLD2	LabelOLD3
aa	1	43	632
bb	2	5	3
cc	3	3	2

I also have other table called 'Labels', containg the old field's names, the new ones, plus the tooltips for the Comments in the espressions and the field No that i'll use to show/hide columns:

FieldNameOld	FieldNameNew	No	Tooltip
LabelOLD1	LabelNEW1	1	Label 1
LabelOLD2	LabelNEW2	2	Label 2
LabelOLD3	LabelNEW3	3	Label 3
LabelOLD4	LabelNEW4	4	Label 4

So, in the atached you can see both tables, and the table 'MAIN TABLE Goal' which is what i want to achieve but dynamically.

To do thath I suspect the tables Data and Labels should be joined or crossed or something.

Please could anyone help

Thx!

[arvind_patil]

Hi Pedro,

Please convert first table in cross table and then simply concatenate it.

Table1:

Crosstable (FieldNameOld, Vaqlue, 1)

LOAD.

.

.

From Table1;

Concatenate(Table1)

LOAD.

.

.

From Table2;

Now you can create dynamic output as required you

Thanks,

Arvind Patil

[sunny_talwar]

Not sure what you mean when you say dynamically, but is this what you need?

=Only({<FieldNameOld = {'LabelOLD1'}>} FieldNameNew)