Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
What is the way to create cross table?
i tried to make 3 columns: ID_NUMBER, NAME, MONTH.
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...
Works good. thank you.
Can you guide me step by step how to do it using Wizards?
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
Here is a video that walk you through how to load cross tables