CROSS TABLE

[#1]

HI,

What is the way to create cross table?

i tried to make 3 columns: ID_NUMBER, NAME, MONTH.

[MK_QSL]

Use below in script.

TableName:

CrossTable(Month, DATA, 2)

LOAD ID_NUMBER,

     NAME,

     Jan,

     Feb,

     Mar,

     Apr,

     May,

     Jun,

     Jul,

     Aug,

     Sep,

     Oct,

     Nov,

     Dec

FROM ..... your table path...

[#3]

Works good. thank you.

Can you guide me step by step how to do it using Wizards?

[MK_QSL]

Go to the Script Editor..

Click on Table Files

Select File from appropriate location.

Now you can see Table, Header Size, Lables... Make sure you have embedded labels selected

Click Next Next (i.e. Two Times)

You will get screen from where you have to select Cross Table

Write Now Qualifier Fields.. for you 2 (i.e. ID_NUMBER and NAME)   

Attribute Filed ... for you is Month

Data Field ... for you is Data or sale or value whatever you want to given name

OK

FINISH

OK

RELOAD

[Josh_Good]

Here is a video that walk you through how to load cross tables

Loading Cross Tables