topic Re: naming columns in QlikView

naming columns

Wed, 02 Apr 2014 04:32:47 GMT

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

Re: naming columns

tresB — Wed, 02 Apr 2014 04:39:22 GMT

Could you post a sample excel?

Re: naming columns

arjunkrishnan — Wed, 02 Apr 2014 04:39:41 GMT

Use Cross Table Is Possible One ..Ur Field Become One Column Value... Or ...Use Condition

Re: naming columns

VishalWaghole — Wed, 02 Apr 2014 04:45:39 GMT

Hi wrestler,

You can use cross table option for this type of scenario.

but if possible then please post your dummy data.

- Regards,

Vishal Waghole

Re: naming columns

its_anandrjs — Wed, 02 Apr 2014 06:39:31 GMT

Load data one by one see the code below

Load

Tech:rahul as Tech

From location;

Load

Tech:padma as Tech

From location;

Load

Tech:manoj as Tech

From location;

Load

Tech:asha as Tech

From location;

Load

Tech:vinod as Tech

From location

If columns are same qlikview load single table with multiple table.

Thanks & Regards

Re: naming columns

arjunkrishnan — Wed, 02 Apr 2014 06:44:20 GMT

Hi wrestler.,

See This Qvw ...It's helpfull For U ....

Re: naming columns

Wed, 02 Apr 2014 06:48:18 GMT

Try this

Test123:

CrossTable(TechName,TechValue,8)

LOAD [Sentiment Score],
Sentiment,
Date,
[Source Name],
Author,
Location,
[Fb Likes/Youtube view],
[Topic: Calvin Klein],
Tech:vinod,
Tech:asha,
Tech:rahul,
Tech:raj,
Tech:neetha,
Tech:seema
FROM

(ooxml, embedded labels, table is Sheet1);

Res:
NoConcatenate
Load [Sentiment Score],
Sentiment,
Date,
[Source Name],
Author,
Location,
[Fb Likes/Youtube view],
[Topic: Calvin Klein],
subfield(TechName,':',2) as TechName,
TechValue

Resident Test123;

Drop Table Test123;

Re: naming columns

arjunkrishnan — Wed, 02 Apr 2014 06:54:14 GMT

Hi wrestler.,

CrossTable(TECH, VALUES, 😎

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

[Create a dash board(1).xlsx]

(ooxml, embedded labels, table is Sheet1);

Show Below Image Wht will Happening On Here ...

Re: naming columns

Wed, 02 Apr 2014 07:13:26 GMT

Hi Wrstler,

CrossTable(Tech, Data, 7)

LOAD [Sentiment Score],

Sentiment,

Date,

[Source Name],

Author,

Location,

[Fb Likes/Youtube view],

[Topic: Calvin Klein],

Tech:vinod,

Tech:asha,

Tech:rahul,

Tech:raj,

Tech:neetha,

Tech:seema

FROM

(ooxml, embedded labels, table is Sheet1);

try this one it will work.

Re: Re: naming columns

Wed, 02 Apr 2014 09:41:59 GMT

Hi Kiran 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

Re: naming columns

tresB — Wed, 02 Apr 2014 09:46:01 GMT

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);

Re: Re: naming columns

Wed, 02 Apr 2014 09:47:50 GMT

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

Re: Re: Re: naming columns

Wed, 02 Apr 2014 09:51:19 GMT

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;

Re: Re: naming columns

Wed, 02 Apr 2014 09:56:03 GMT

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

Re: naming columns

VishalWaghole — Wed, 02 Apr 2014 10:00:57 GMT

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

Re: naming columns

arjunkrishnan — Wed, 02 Apr 2014 10:03:37 GMT

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;

Re: Re: naming columns

Wed, 02 Apr 2014 10:05:17 GMT

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

Re: Re: naming columns

its_anandrjs — Wed, 02 Apr 2014 10:08:06 GMT

Load like this

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);

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

Re: Re: Re: naming columns

Wed, 02 Apr 2014 10:08:22 GMT

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

Re: naming columns

VishalWaghole — Wed, 02 Apr 2014 10:08:46 GMT

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