Categorize columns with the column name, and create a table.

[gizzel123]

Hi all ,

I have columns from database as names: eg sales_1,sales_2, sales_3......cust_1,cust_2,cust_2.

Header 1	Header 2	Header 3	Header 4
category	1	2	3
sales	value	value	value
cust	value	value	value

how can i do that, please suggest.

its very urgent for me.

thanks in advance.

[Gysbert_Wassenaar]

You probably need to use the crosstable function in the script. Can you post an example source file?

[#3]

PLZ post your sample data file.

thanks

S Shrivas

[amit_saini]

Hi,

Yes as Gysbert suggested cross table work here:

The Crosstable Load

Thanks,
AS

[gizzel123]

table:

col1,

col2,

col3....,

sales_asco,

sales_cmr,

sales_cq,

...,

cust_asco,

cust_cmr,

cust_cq.
this is the table...

now i have to extract the "cust , sales,...." as category....(not the first 41 columns) and again ASCO,CMR,CQ as the filed names in qlikview .

[gizzel123]

Sorry guys i cant post the data i m using.