Cross Table?

[#1]

Hi All,

Please i have this cross table

July	Sales
Cairo	200
Alex	300
August	Sales
Cairo	400
Alex	500

i nedd to load it and make (july,August) as dimension "Month"

and make (Cairo,Alex) as dimension "Country"

How to do that?

[nagaiank]

For your test data , the following script will help:

Temp:

LOAD *, If(Sales='Sales',City, Peek(Month)) as Month;

load * Inline [

City, Sales

July,Sales

Cairo,200

Alex,300

August,Sales

Cairo,400

Alex,500

];

Data:

NoConcatenate

LOAD City, Sales, Month Resident Temp

Where Sales <> 'Sales';

DROP Table Temp;