Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gizzel123
Creator
Creator

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

Hi all ,

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

Header 1Header 2Header 3Header 4
category123
salesvaluevaluevalue
custvaluevaluevalue

how can i do that, please suggest.

its very urgent for me.

thanks in advance.

5 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Not applicable

PLZ post your sample data file.

thanks

S Shrivas

amit_saini
Master III
Master III

Hi,

Yes as Gysbert suggested cross table work here:

The Crosstable Load

Thanks,
AS

gizzel123
Creator
Creator
Author

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
Creator
Creator
Author

Sorry guys i cant post the data i m using.