How I can Tranform a Excel Data

[#1]

Hi all,

I´m new in Qlickview and I have a Excel File with Budget by unit, but the format is something like this

Group_Code     Item_Code     Jan     Feb     Mar     Apr

     a0001          XXXXXX          20       15      25       32

I ned this in other format:

Group_Code    Item_Code    Month     Quantity

     a0001         XXXXXX         Jan            20

     a0001         XXXXXX         Feb           15

I ask how I can do this? .

I appreciate your Help

[#2 · Accepted solution]

something like:

crosstable(month, quantity, 2)

load group_code

       item_code

       jan

       feb

       mar

       apr

from ...

[#3]

Thamks a lot....

Now it´s working fine....

I appreciate your help...

[swatitomar]

heyy hiii

Is there any other way to transform the data, other thn crosstable

[Anonymous]

Try to load data in following way, thhis will also transform it.....

Directory;

LOAD Group_Code,
     Item_Code as Month,
   

FROM
check.xls
(biff, embedded labels, table is [Sheet1$]);

concatenate

LOAD Group_Code,
     Item_Code,
   Feb as Month

FROM
check.xls
(biff, embedded labels, table is [Sheet1$]);

Regards

Nitin

[swatitomar]

Thank u Sir .....

For this we have to load the data 12 times for each month..

Sir is dis is the best way to transform the data..

[Anonymous]

If data size is huge , then it has to be done otherwise crosstable is there,

or use any etl process for transformation...

[swatitomar]

Okk Sir...  thank you for the question and ans also..

[Anonymous]

maine kaunsa ques poocha???????

[swatitomar]

prince se pucha tha kl