Expression Columns into rows

[mohanrajsubrama]

Hi Guys,

              I have a Table in this format.

country	gender	current year	previous year	change in %
poland	male	1000000	800000	20
	female	60000	40000	33

But my Client requirement should be in this format.when i drag the expressions into rows the table gets crossed.

country	years	male	female
poland	current year	1000000	60000
	previous year	800000	40000
	change in %	20	33

here for current year,previous and % change were three different expressions.how can i acheive this any suggestions.

Regards,

Mohanraj Subramanian.

[nirav_bhimani]

HI,

For that  I think you have to use crosstable concept in script and also calculate all the Expression in script level.

Regards,

Nirav Bhimani

[neha_shirsath]

Hii,

Please find the attachment.Hope it will help you.

[mohanrajsubrama]

Hi Guys,

              Thanks for ur Quick Reply.Its working fine now.

Regards,

Mohanraj Subramanian.

[#5]

hi

this code also helps you in future

LOAD country,

     gender,

     [current year],

     [previous year],

     [change in %]

FROM

C:\Users\Desktop\test28.xlsx

(ooxml, embedded labels, table is Sheet1);

LOAD  'current year' as years,[current year] as male,[current year] as female

FROM

C:\Users\Desktop\test28.xlsx

(ooxml, embedded labels, table is Sheet1);

Concatenate LOAD  'previous year' as years,[previous year] as male,[previous year] as female

FROM

C:\Users\Desktop\test28.xlsx

(ooxml, embedded labels, table is Sheet1);

Concatenate LOAD  'change in %' as years,[change in %] as male,[change in %] as female

FROM

C:\Users\Desktop\test28.xlsx

(ooxml, embedded labels, table is Sheet1);

thanks.