naming columns

[#1]

Hi i have a excel sheet of which i have to put a dashboard , In my excel sheet i have columns names as

Tech:rahul,  Tech:padma, Tech:manoj,Tech:asha ,Tech:vinod

my question is i want to bring all the name under one column as Tech ,.

How do i do that

[tresesco]

Well, if you are using personal edition qv, here is the script I used :

CrossTable(Tech, Data, 😎

LOAD [Sentiment Score],

     Sentiment,

     Date,

     [Source Name],

     Author,

     Location,

     [Fb Likes/Youtube view],

     [Topic: Calvin Klein],

     [Tech:vinod] as vinod,

     [Tech:asha] as asha,

     [Tech:rahul] as rahul,

     [Tech:raj] as raj,

     [Tech:neetha] as neetha,

     [Tech:seema] as seema

FROM

[<Yourpath>\Create a dash board.xlsx]

(ooxml, embedded labels, table is Sheet1);

[#3]

Hi Tressco  thanks for the reply but i tried all the things its giving the error , Iam new to qlik view

i have a excel sheet which i will be forwarding to u , In that excel sheet there are many fields , and my task is to build the dashboard

. I wanted to know how to rename the fields topic: jeans, topc: lee, topc:spykar and so on  ,as TOPIC and include all the jeans under topic

plz find the attachement

[#4]

Hi,

Try this

Test123:

CrossTable(Topic,TopicValue,1)

LOAD [Topic Content ID],
[Topic: Calvin Klein],
[Topic: Diesel],
[Topic: Killer Jeans],
[Topic: Lee Cooper Jeans],
[Topic: Lee Jeans],
[Topic: Levis],
[Topic: Pepe Jeans London],
[Topic: Spykar],
[Topic: Wrangler Jeans]
FROM

(ooxml, embedded labels, table is Topic);

Res:
NoConcatenate
Load [Topic Content ID],
SubField(Topic,':',2) as Topic
Resident Test123;

Drop Table Test123;

[#5]

hi Ravi no its not working , After loading the script  as u suggested its showing an error like could not find fil

[VishalWaghole]

Hi Wrestler,

Please find attached file, it will help you.

I have wrote script for that as..

CrossTable(Name, Data, 7)

LOAD * FROM

(ooxml, embedded labels, table is Sheet1);

- Regards,

Vishal Waghole

[arjunkrishnan]

Hi Wrstler,

Pls Reffer This Helpful For U....

If U Can't Able To Open this File Means,

Script Code:

Table:

CrossTable(Topic, Values)

LOAD [Topic Content ID],

     [Topic: Calvin Klein],

     [Topic: Diesel],

     [Topic: Killer Jeans],

     [Topic: Lee Cooper Jeans],

     [Topic: Lee Jeans],

     [Topic: Levis],

     [Topic: Pepe Jeans London],

     [Topic: Spykar],

     [Topic: Wrangler Jeans]

FROM

[1223.xlsx]

(ooxml, embedded labels, table is Topic);

Table2:

LOAD *,

subfield(Topic,':',2) as JEANS_Name

Resident Table;

DROP Table Table;

[#8]

Hi vishal the file u attached is not opening , when i double clik on it the error messeg is like u cannot open it becuase the file is open too many times , can u paste the script on community itself

[its_anandrjs]

Load like this

A:

CrossTable(Topic,TopicValue,1)

LOAD [Topic Content ID],

     [Topic: Calvin Klein],

     [Topic: Diesel],

     [Topic: Killer Jeans],

     [Topic: Lee Cooper Jeans],

     [Topic: Lee Jeans],

     [Topic: Levis],

     [Topic: Pepe Jeans London],

     [Topic: Spykar],

     [Topic: Wrangler Jeans]

FROM

(ooxml, embedded labels, table is Topic);

B:

NoConcatenate

Load [Topic Content ID],

SubField(Topic,':',2) as TopicName

Resident A;

Drop Table A;

And when using this script change your source location like in this line

Hope this helps

[#10]

Please post the exact script what you are using

I think you are using the same script of myne without modifying the file path

This is myne  

FROM

(ooxml, embedded labels, table is Topic);

You should use your file path insteadof my path

[VishalWaghole]

Hi,

please find script code that i have created.

CrossTable(Name, Data, 7)

LOAD * FROM

[Create a dash board.xlsx]       // make sure that, this location is your file stored folder location

(ooxml, embedded labels, table is Sheet1);

- Regards,

Vishal Waghole