Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

How I can Tranform a Excel Data

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

1 Solution

Accepted Solutions
Not applicable

How I can Tranform a Excel Data

something like:

crosstable(month, quantity, 2)

load group_code

       item_code

       jan

       feb

       mar

       apr

from ...

11 Replies
Not applicable

How I can Tranform a Excel Data

something like:

crosstable(month, quantity, 2)

load group_code

       item_code

       jan

       feb

       mar

       apr

from ...

Not applicable

How I can Tranform a Excel Data

Thamks a lot....

Now it´s working fine....

I appreciate your help...

swatitomar
New Contributor III

Re: How I can Tranform a Excel Data

heyy hiii

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

gupta_n8
Valued Contributor II

Re: How I can Tranform a Excel Data

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
New Contributor III

Re: How I can Tranform a Excel Data

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..

gupta_n8
Valued Contributor II

Re: How I can Tranform a Excel Data

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

or use any etl process for transformation...

swatitomar
New Contributor III

Re: How I can Tranform a Excel Data

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

gupta_n8
Valued Contributor II

Re: How I can Tranform a Excel Data

maine kaunsa ques poocha???????

swatitomar
New Contributor III

Re: How I can Tranform a Excel Data

prince se pucha tha kl