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

[VishalWaghole]

You can also use individual columns instead of *

CrossTable(Name, 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

[Create a dash board.xlsx]

(ooxml, embedded labels, table is Sheet1);

[#3]

Hi Anand super bro

Its working But how about the table contenet which also has topic : jeans,

what should i do for that

[#4]

Hi Wrstler,

CrossTable(Jeans, Data)

LOAD [Topic Content ID],

     [Topic: Calvin Klein] as Calvin_Klein,

     [Topic: Diesel] as Diesel,

     [Topic: Killer Jeans] as Killer,

     [Topic: Lee Cooper Jeans] as Lee_Cooper,

     [Topic: Lee Jeans] as Lee,

     [Topic: Levis] as Levis,

     [Topic: Pepe Jeans London] as Pepe,

     [Topic: Spykar] as Spykar,

     [Topic: Wrangler Jeans] as Wrangler

FROM

(ooxml, embedded labels, table is Sheet3);

you can use this it will work.

[#5]

Thanks bro its working ,