Dynamic columns in table.

[Anonymous]

Hello,

Let's say we have following input set:

A   2000   1

B   2000   2

A   2001   5

B   2001   4

A   2002   2

B   2002   8

I need someting similar to Time Chart Wizard which will generate report:

     2000   2001  2002

A        1        5        2

B        2        4        8

but the key thing is that with wizard I'm forced to add all columns ( 2000, 2001, 2002 )  manually.

Is there any better way to do that and automate that process to avoid "clicking". If we have 3 columns

it makes no difference, but when we are close to 50 it's getting painful ?

[MayilVahanan]

Hi

PFA

Are you looking like this?

[#3]

Hello ,

but if i have this table :

A   2000   d1

B   2000   d2

A   2001   d5

B   2001   d4

A   2002   d2

B   2002   d8

and i want :

     2000   2001    2002

A       d1      d5        d2

B       d2      d4        d8

How i can do it?

Thank

Wava

[jagannalla]

Hello,

This can be done by Generic Load. Here is the script.

T1:

LOAD * INLINE [

    F1, F2, F3

    A, 2000, 1

    B, 2000, 2

    A, 2001, 5

    B, 2001, 4

    A, 2002, 2

    B, 2002, 8

];

Generic LOAD F1,F2,F3 Resident T1;

- Take the table box and add F1,2000,2001,2002 and you will see the below result.

F1	2000	2001	2002
A	1	5	2
B	2	4	8

For your reference I'm attaching sample file please check it.

Hope it helps you.

Cheers!!

Jagan Nalla

[#5]

Great answer!!!

The original post is not mine i can't vote, but this is 10 point answer!!!

thanks

Wava

[Anonymous]

Tell me what mistakes do i made while replicating properties of your component to get "the same" result?  At this point I get aggregated ( icon with plus ) results and no answer from value property..

[whiteline]

Expand to see the years. Click on the year header and drug it. You should see a blue arrow.

Move it to the right top so that it become horizontal. Release.

[Anonymous]

It is close, but using column as row is possible only in "pivot chart", but what If I have

         2000 2001 2002

A  C        1      2      3

B  D        5      6     7

I'll get  just :

A [+], C

B [+]. <nothing>

Is there any way to get rid of that aggergation or I'll have to do it by my self with some js script and

external component ? Maybe there is other way to join table and  pivot table components together, but

there might be problems with grater number of rows then it's possible to display on screen.

[MayilVahanan]

HI

Can you please upload sample file? Will check n give the solution. Its helps us to solve your requirement.

[Anonymous]

Uploaded, as You can see [+]'s causes problems.