Cross Table

[#1]

What is cross table? How it's created? Why we need this??

Anybody please help me!!!!!

[its_anandrjs]

Hi,

Cross table is a table from which you make any number of rows comes under single column

like

ColA,ColB,ColC,ColD

and you want to cross ColC,ColD then it comes under single column

and rest are ColA,ColB individuals

like in code

CrossTable(orgname, Data, 2)

LOAD ColA,

     ColB,

     ColC,

     ColD

FROM

Data

In Data ColC,ColD are comes

and in orgname ColA,ColB

Regards,

Anand

[SunilChauhan]

crosss usse in case you have to combine multiple columns into 2 column

i.e all column name in one column and valuee in anotheer column

see the example below

EmpId,Ename,jan'10,feb'10,mar'10,apr'10
1,sk,100,200,300,400
2,Vk,500,600,700,800
3,tk,1500,1600,1700,1800

then
using cross table we can have 4 columns
EmpId,Ename,Month,Value

where month contains jan'10,feb'10,mar'10,apr'10
and value contains  100,200,300,400,500,600,700,800,1500,1600,1700,1800

[its_anandrjs]

Hi,

See the attached sample file for clearity.

Regards,

Anand

[SunilChauhan]

take a new qvw and

take excel file atached

Control+E-> tabl files->next->next ->Cross table->

down no of qulified field give thee no (in example attached 1)

give the name of attribute and vales

finish ok

and drag all filed into tablebox

this is all about cross tablee

we need to use cross table for budget files  for ex.

[#6]

Thanks Sunil & Anandrjs..............................

[its_anandrjs · Accepted solution]

Hi,

See the another demo of the file Cross table here it is showing Question and its information

like

Table:

CrossTable(Que, Data, 2)

LOAD

     ColA,

     ColB,

     De01,

     De03,

     De05,

     De07,

     De09

FROM

CrossData.xlsx

(ooxml, embedded labels, table is Sheet1);

2 means form column 2 the table will get crossed it will depends on you from which column you want a cross table so just increase or decrease it from there.

Regards,

Anand

[SunilChauhan]

anup what is difference beetween my attachment and anand's attachment

[#9]

Both are same sunil.