for each in script

annalisa_carado — Wed, 05 Apr 2017 08:27:50 GMT

Hi all, I have a question about this situation:

I have this table :

Key	MeasureA	MeasureB	MeasureC
AAAAA	10	20	30

and I want a final table like this:

I wrote the static solution:

TMP:

load

Key,

'MeasureA' as Measure,

MeasureA as Value

resident MyTable;

Concatenate

load

Key,

'MeasureB' as Measure,

MeasureB as Value

resident MyTable

.....

I would like to get this dinamyc (maybe in future will have new dimensions), using for each next .. but i'm not having success.

Any help?

Re: for each in script

Anonymous — Wed, 05 Apr 2017 08:31:02 GMT

Try cross table Annalisa.

crosstable(measure,Value,1)

Load * from <your initial table>;

MK_QSL — Wed, 05 Apr 2017 08:34:24 GMT

CrossTable (Measure, Value)
Load

Key,

MeasureA,

MeasureB,

MeasureC

From TableName;