topic Re: How I can Tranform a Excel Data in QlikView

How I can Tranform a Excel Data

Thu, 16 Jun 2011 18:52:11 GMT

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

How I can Tranform a Excel Data

Thu, 16 Jun 2011 20:01:32 GMT

something like:

crosstable(month, quantity, 2)

load group_code

item_code

jan

feb

mar

apr

from ...

How I can Tranform a Excel Data

Thu, 16 Jun 2011 20:40:18 GMT

Thamks a lot....

Now it´s working fine....

I appreciate your help...

Re: How I can Tranform a Excel Data

swatitomar — Thu, 12 Dec 2013 10:12:01 GMT

heyy hiii

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

Re: How I can Tranform a Excel Data

Anonymous — Thu, 12 Dec 2013 10:51:07 GMT

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

Re: How I can Tranform a Excel Data

swatitomar — Thu, 12 Dec 2013 11:07:01 GMT

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

Re: How I can Tranform a Excel Data

Anonymous — Thu, 12 Dec 2013 11:10:17 GMT

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

or use any etl process for transformation...

Re: How I can Tranform a Excel Data

swatitomar — Thu, 12 Dec 2013 11:13:29 GMT

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

Re: How I can Tranform a Excel Data

Anonymous — Thu, 12 Dec 2013 11:18:06 GMT

maine kaunsa ques poocha???????

Re: How I can Tranform a Excel Data

swatitomar — Thu, 12 Dec 2013 11:20:43 GMT

prince se pucha tha kl

Re: How I can Tranform a Excel Data

Anonymous — Thu, 12 Dec 2013 11:23:58 GMT

kkk,

maine aur bhi diya hai kam use, poochna usase.

dekhte hai kaun pehle banata hai

Re: How I can Tranform a Excel Data

swatitomar — Thu, 12 Dec 2013 11:26:19 GMT

ok ok....

today he is on leave..kl try krungi