Create dimension from two dimensions

[danielrogra]

Hi All

I have two dimensions as follows:

Dimension1	Dimension2
A	A.1
A	A.2
B	B.1
B	B.2

and I want to create the following dimensions

New dimensions	Total
A	sum where dimensions2 in (A.1,A.2)
B	sum where dimensions2 in (B.1,B.2)
C	sum where dimensions2 in (A.2,B.2)

How can I create that?

Thanks in advance

Regards

[joseph_eftamand]

Hi Daniel,

Sorry, I'm not sure I understand, can you explain your question again? You're just creating a new dimension and assigning the text strings 'A','B','C' to different combinations of dimension2.

Perhaps I have misunderstood your requirement.

Joseph

[juraj_misina]

Variation of Nagesh's suggestion:

DataWithNewDimension:
LOAD  
    Dimension1,
    Dimension2
FROM [lib://mylink]  
(html, utf8, embedded labels, table is @1);  

Left Join
Load * Inline [  
Dimension2, NewDimension1
A.1, A
A.2, A
A.2, C
B.1, B
B.2, B
B.2, C
];